Page 96 - Computer Software Application TP - Volume 1
P. 96
COMPUTER SOFTWARE APPLICATION - CITS
TASK 5 :Test Query Performance:
Run queries and observe the performance improvement. For example:
SELECT * FROM employee WHERE department id = 1;
Drop Index (Optional):
If needed, you can drop an index:
DROP INDEX idx department id ON employee;
Questions
1 How do I check existing indices on a table?
2 How do I add a simple Index to a column?
3 How do I remove an Index from a table?
4 How can I check the performance improvement after adding an Index?
5 Can I add a unique Index to a column?
81
CITS : IT & ITES - Computer Software Application - Exercise 25 CITS : IT & ITES - Computer Software Application - Exercise 25