releases.shpreview
ClickHouse/ClickHouse Blog/ClickHouse projections now behave like true secondary indexes

ClickHouse projections now behave like true secondary indexes

$npx -y @buildinternet/releases show rel_LqB7yWFu5k1aF9R5D46L1

ClickHouse now supports granule-level pruning for lightweight projections, enabling them to act as true secondary indexes that work together to dramatically speed up multi-filter queries without duplicating full table data.

Fetched April 14, 2026