InfoQ 中文T2·68 pts
- Liquid Clustering performs best for point queries, time-range aggregations, and large aggregations, making it a suitable default.
- ZOrdering has a hidden failure mode: time-range queries are 78% slower than simple partitioning when date is a secondary or tertiary key.
- ZOrdering only outperforms Liquid Clustering in stable, high-selectivity multi-predicate workloads where filter columns exactly match clustering keys.