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