Which of the following is a potential problem caused by adding too many indexes to a relational database?
A) Too many indexes can slow the performance of the database when there is a large amount of direct retrieval activity.
B) Updating the indexes when the data is updated can slow down queries executing at the same time.
C) Maintaining the security of the database can be adversely affected by the presence of a large number of indexes.
D) All of the above.
E) None of the above.

Question

Quizplus · Accepted Answer

Updating the indexes when data is updated can indeed slow down queries executing at the same time because the database must also update each index associated with the modified data, which can be time-consuming especially with a large number of indexes.

Which of the Following Is a Potential Problem Caused by Adding