How to Create an Index in MS-SQL

To create an index use the create index statement specifying the name of the table, the name of the index and the columns forming the index key. Additionally you can specify if the index allows duplicates or unique keys.

create unique index emp_ix1 on employee ( emp_id );

create index emp_ix2 on employee ( last_name, starting_date );

IN THIS PAGE