Page 95 - Computer Software Application TP - Volume 1

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