ClickHouse ORDER BY Is a Storage Decision, Not a Query Clause
In ClickHouse MergeTree tables, ORDER BY is the physical sort order of your data, not a query clause. Here's how the sorting key drives sparse-index pruning, with a worked multi-tenant example.
clickhouse