Query Speed Skip Indexes Projections Materialized Views Dictionaries Query Optimization

Query Speed

Query Speed

The tricks that make scans over billions of rows fast.

The tricks that make scans over billions of rows fast.

Sections

6.1
Skip IndexesData-skipping indexes
6.2
ProjectionsPre-sorted alternate layouts
6.3
Materialized ViewsPush-based pre-aggregation
6.4
DictionariesFast in-memory lookups
6.5
Query OptimizationVectorized execution

Mutations (UPDATE / DELETE)

Why they're heavyweight, async rewrites

Skip Indexes

Data-skipping indexes