Optimization

ClickHouse Rewrites the Query Before It Plans It

Oct 23, 2026 19 min read Jay Hubbert

ClickHouse inlines aliases, runs 47 ordered tree passes, prunes columns and rewrites count(*) into a metadata read before planning.

ClickhouseInternalsQuery planOptimization

Read more →