Create Index « Index « SQL Server / T-SQL






1.Create index full syntax template
2.Create index based on two columns
3.Create a nonclustered index
4.Create a composite index: the compound values in both columns must be unique
5.Create an index for a table
6.Shows the use of the INDEX hint