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