Thanks for the suggestion, Mike. I tried both variants with explain analyze, and the nulls last version is overall faster. (See the attached document with the results for a single copy.)
I made a new branch using nulls last on the order by and posted it to the working repo. It still resolves the issue for our example holds shelf where there are multiple copies missing. Since it about 1 ms faster than the is not null version, we should use this one:
Thanks for the suggestion, Mike. I tried both variants with explain analyze, and the nulls last version is overall faster. (See the attached document with the results for a single copy.)
I made a new branch using nulls last on the order by and posted it to the working repo. It still resolves the issue for our example holds shelf where there are multiple copies missing. Since it about 1 ms faster than the is not null version, we should use this one:
https:/ /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ dyrcona/ lp1827250_ last_captured_ hold_fix_ nulls_last