4/30/2015 5:52:58 PM

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