v.22.4Performance Improvement
New Query Plan Optimization Improves Efficiency by Evaluating Functions After ORDER BY
A new query plan optimization. Evaluate functions afterORDER BYwhen possible. As an example, for a querySELECT sipHash64(number) FROM numbers(1e8) ORDER BY number LIMIT 5, functionsipHash64would be evaluated afterORDER BYandLIMIT, which gives ~20x speed up. #35623 (Nikita Taranov).