Multiple choice technology databases

Multiple indexes on a table will lead to...

  1. Increase the performance during SELECT operation

  2. Degrade the performance during INSERT operation?

  3. Degrade the performance during the UPDATE or DELETE operation

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

While multiple indexes can speed up SELECT queries by avoiding full table scans, every index must be updated during INSERT, UPDATE, and DELETE operations. Consequently, having numerous indexes improves read performance at the expense of write and modification performance.

Keep practicing — related questions