What is the main tradeoff of adding indexes?
Practice this question from Quiz: DBMS for Java, with options and an explanation.
Question
What is the main tradeoff of adding indexes?
Option A — Correct answer
Faster reads but extra write and maintenance cost
Indexes accelerate lookup but must be maintained on data changes.
Option B
Slower reads and no write cost
Option C
No storage usage
Option D
Automatic removal of all locks