+ 5
This type is called as composite index. It has multiple col defined in index definition. Create Index ix1 on TableName (col1,col2,col3) You can define it to be as unique or clustered or non clustered, etc.. Above example will create non clustered index.
12th Jul 2016, 9:32 AM
Ashutosh Singh