ClickHouse projections now behave like true secondary indexes

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 13 Jan, 00:00 UTC

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.

Sources

• T1ClickHouse projections now behave like true secondary indexesDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale13 Jan, 00:00