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 cohumn?
UPDATE T SET City'Hyderabad where Name'Apanitha'
INSERT into T values Aganitha, Hyderatach
SELECT CIty where Name'Aganitha
SELECT Name where CityHyderabad
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
