"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 ...
Nonclustered indexes are implemented in the following ways: UNIQUE constraints** When you create a UNIQUE constraint, a unique nonclustered index is created to enforce a UNIQUE constraint by default.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results