CLUSTER BY in Fabric Warehouse: when the magic shows up and when it doesn’t!

Microsoft's announcement post for data clustering in Fabric Warehouse promised 24x speedups. So I built a 100-million-row clickstream table and tested it myself. The result is more nuanced than the marketing - and more useful for anyone deciding whether to actually adopt this feature. Here's what 40% less CPU and 69% less I/O looks like - and why elapsed time barely moved.

The post CLUSTER BY in Fabric Warehouse: when the magic shows up and when it doesn’t! appeared first on Data Mozart.