Use Statistics to Improve Prewhere Condition Ordering

Why it matters

This feature addresses the issue of inefficient ordering of PREWHERE conditions by leveraging collected statistics. It helps ClickHouse execute queries more efficiently by prioritizing the most selective conditions first, thus reducing data scanning and speeding up query execution.

How to use it

This optimization is applied automatically when using PREWHERE clauses. No additional user configuration is necessary as the optimizer uses available statistics to reorder the conditions dynamically.