"shortAnswer": "A clustered columnstore index (CCI) is the optimal choice for exclusively analytical workloads. It replaces the rowstore, stores data column-by-column for maximum compression (5–10x ...