Indexes
Indexes should be named so it is obvious what table and column the index is on and what kind of index it is.
Last updated
Indexes should be named so it is obvious what table and column the index is on and what kind of index it is.
Last updated
Index Type
Naming Model
Example
Clustered
CIDX_[YourTableName]_[ColumnName]
CIDX_DimCustomer_CustomerCK
Non-Clustered
NCIDX_[YourTableName]_[ColumnName]
NCIDX_DimCustomer_SourceSystemKey