Question: Consider a table T with three columns named ID , Name and City. Which statements are likely to deteriorate in performance after adding an index
Consider a table T with three columns named ID Name and City. Which statements are likely to deteriorate in performance after adding an index to NAME column?
which option is correct olnly one could be correct?
UPDATET SET City Hyderabad where NameAganitha
INSERT into T values Aganitha, Hyderabad
O SELECT City where NameAganitha
SELECT Name where City Hyderabad
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
