firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Skip NULL keys in strong equality hash and merge joins

Open dyemanov opened this issue 7 months ago • 0 comments

Soluation for #7769.

Skip NULLs keys at the evaluation time and do not put appropriate records into the hash table (for hash joins) or into external sort blocks (for merge joins).

Also implement (optional) flag-less sort keys, this often saves 25-50% of the key length inside the sort record.

dyemanov avatar May 07 '25 08:05 dyemanov