Index MSSQL Tutorial

CREATE [CLUSTERED|NONCLUSTERED] INDEX index_name
    ON table_name (column_name_1 [ASC|DESC] [, 
column_name_2 [ASC|DESC]]...)