firebird
firebird copied to clipboard
Skip NULL keys in strong equality hash and merge joins
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.