Great post, Rahul! You’ve nailed the key trade-offs perfectly.

The Appeal: LC is “set it and forget it” data management—no more manual OPTIMIZE jobs or performance firefighting.

The Reality Check: Single-column clustering works great for high-cardinality fields, but teams with complex multi-dimensional queries will miss Z-Ordering’s flexibility.

The Gotcha: LC and partitioning don’t play together—migration means rip-and-replace.

Bottom Line: Perfect for streaming workloads and evolving patterns. For specialized, stable queries, Z-Ordering might still be your friend.

Solid breakdown of where the automation trend is heading!

Cheers, Lou.