Which of the following is a disadvantage of using an index?
A) You can only add an index when the table is created.
B) You can't use indexes with foreign keys.
C) Record retrieval is less efficient.
D) The index must be updated whenever the data in the database changes.

Question

Quizplus · Accepted Answer

Indexes can speed up data retrieval but require additional operations to maintain them when the underlying data changes. This can lead to overhead during data insertions, updates, or deletions, as the index must be kept in sync with the data.

Which of the Following Is a Disadvantage of Using an Index