Sql Server, Query Optimization.
index_name ON table_name (column1 [ASC | DESC], column2 [ASC | DESC], ...); CREATE CLUSTERED INDEX idx_name_and_birthdate ON Person (Last_Name ASC, First_Name ASC, Birthdate DESC); CREATE NONCLUSTERED INDEX idx_last_name ON Employee (Last_Name); Clustered Index Uniqueness — There can be only one