Page 95 - Computer Software Application TP - Volume 1
P. 95

COMPUTER SOFTWARE APPLICATION - CITS
























































           View the Table Structure:

           DESC employees;

           TASK 4 :Add Index:

           Single Column Index-
           CREATE INDEX idx department id ON employee (department id);











           Multiple Column (Composite) Index-
           CREATE INDEX idx department salary ON employee (department id, salary);
           View Index Information:
           SHOW INDEX FROM employee;





                                                           80
                               CITS : IT & ITES - Computer Software Application - Exercise 25
   90   91   92   93   94   95   96   97   98   99   100