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