SQL: Create a SQL Index

4/30/2015 5:52:58 PM

SQL

Indexes

Create a sql index. It can contain 1 or multiple columns. It can also be a covering index which includes additional columns.

CREATE INDEX [IX_TableName__Column1_Column2] ON [dbo].[TableName] ([Column1], [Column2])
--optional includes
--INCLUDE(Col3, Col4, Col5)
GO