Multiple choice technology web technology

INDEX often improves the performance of SELECT. However, degrades the performance of DMLs

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Indexes significantly improve SELECT query performance by providing fast lookup paths. However, they impose overhead on DML operations (INSERT, UPDATE, DELETE) because the index must be updated alongside the table data. This is a fundamental trade-off in database design - faster reads come at the cost of slower writes.

Keep practicing — related questions