Mike
Tips, tricks and solutions for software developers.
 

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