Adding an index to a SQL Server table
By Mike Gledhill
Here's how to add a new index to a SQL Server table:
CREATE INDEX index_name
ON table_name (field_name)
For example:
CREATE INDEX idxMikesIndex
ON tblEmployees (date_of_birth)
Comments