Projection Design for Alternate Sort Orders on Denormalized Tables
Narrow projections let denormalized tables serve multiple sort orders without full duplication.
Seren Almodovar
Section
Denormalization and Join Avoidance Patterns
2 stories in Denormalization and Join Avoidance Patterns.
MergeTree Sort Key Design for Pre-Flattened Wide Tables
How to order columns in a MergeTree table to balance pruning and compression.
Callum Dzenga