Clustered indexes
Use for columns that contain a large number of distinct values
Queries that return large record sets
Columns that are frequently found in WHERE clauses (BETWEEN, , etc)
Never use on a GUID column
Non-clustered indexes
Use for columns that contain a large number of distinct values (if a clustered index already exists).
Queries that do not return large record [...]
