Prewhere

ClickHouse Chooses What Goes into PREWHERE by Cost per Rejected Row

Oct 24, 2026 17 min read Jay Hubbert

ClickHouse moves WHERE conditions into PREWHERE by cost per rejected row, and reads PREWHERE columns in separate read steps.

ClickhouseMergetreePrewhereQuery planningPerformance

Read more →