- Global Rules and
| Btree/Column Store | Unique/Non Unique | Cluster | Non-Cluster |
|---|---|---|---|
| Column Store | Non Unique | CC | CX |
| Btree (Classic) | Unique | UC_<FullTableName>[_xx] or constraint_name(PK, UK) | UX_<FullTableName>[_xx] or constraint_name (PK,UK) |
| Btree (Classic) | Non Unique | IC_<FullTableName>_<details> | IX_<FullTableName>_<details> |
For details in index, the objective of the index could be describe :
- load
- reporting
- extract
- generic