Faster String Aggregations with Dimension Tables

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 01 Oct, 17:19 UTC

When a query groups on long, repeated strings, move the strings into a small dimension table with sorted, narrow integer keys. Aggregate on the keys, then join the strings back in at the very end. The query works as before, though on small fixed-width integers instead of variable-length text.

Sources

• T1Faster String Aggregations with Dimension TablesDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale01 Oct, 17:19