Composite index in SQL Server 2008

Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1687
In SQL 2005 and 2008 we can add up to 16 columns in a index.
Such index that consists of more than one columns is referred as composite index.

CREATE INDEX index_name
ON [table_name] (col1,col2,...col16);

For example.
 CREATE INDEX IX_Student_Composite
ON [Student] (student_Code,student_Name);

Comments or Responses

Login to post response