How to create an Index on Table on multiple columns?

 Posted by vishalneeraj-24503 on 1/13/2014 | Category: Sql Server Interview questions | Views: 532 | Points: 40
Answer:

With the help of Create Index statement,we can create any index on any column(s) in a table.

Syntax:-
Create Index index_name

On table_name(column_name1,column_name2,---,column_n);


For Example:-
Create Index idx_employee_id

On Employee_Master(employee_id,employee_code);


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response