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 Name-Aganitha
INSERT into T values (1, Aganitha, Hyderabad)
O SELECT City where Name-Aganitha
SELECT Name where City Hyderabad

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!