How to create an Index on Table?

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

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

Syntax:-
Create Index index_name

On table_name(column_name);


For Example:-
Create Index idx_employee_id

On Employee_Master(employee_id);


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response