Index-based pruning in ClickHouse

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

Learn how ClickHouse uses primary indexes, lightweight projections, and skip indexes to prune data before reading it. Demonstrated on a 243 million row UK property sales dataset.

Sources

• T1Index-based pruning in ClickHouseDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale15 Apr, 00:00