ClickHouse MergeTree, measured: parts, granules and what ORDER BY does to 10 million rows
The same 10 million rows under three ORDER BY keys: 91 vs 151 MiB on disk, and 8,192 vs 10 million rows read. How MergeTree parts, granules and the sparse index explain it.