Projections

How ClickHouse Picks a Projection to Read

Oct 23, 2026 14 min read Jay Hubbert

ClickHouse scores each projection by the marks it must read, including the parts it cannot serve, and picks the cheapest.

ClickhouseInternalsMergetreeProjectionsQuery planning

Read more →