Named Indexes

Name all indexes.

Named indexes should follow this pattern:

<tableName>_<indexIdentifier>_[C][U]IDX

where indexIdentifier is a unique string describing the index (e.g. CCUser_UserID_IDX).

Clustered indexes should include the "C".  Unique indexes should include the "U".