Bird
0
0

How do multiple indexes on a table affect the performance of INSERT and UPDATE operations?

hard📝 Conceptual Q10 of 15
SQL - Indexes and Query Performance
How do multiple indexes on a table affect the performance of INSERT and UPDATE operations?
AEach index must be updated, increasing the time required for the operation
BIndexes improve <code>INSERT</code> and <code>UPDATE</code> speed by caching data
CIndexes have no effect on <code>INSERT</code> and <code>UPDATE</code> performance
DIndexes only affect <code>SELECT</code> queries and not data modification statements
Step-by-Step Solution
Solution:
  1. Step 1: Understand index maintenance

    When a row is inserted or updated, all indexes on the table must be updated to reflect the change.
  2. Step 2: Impact on performance

    This additional work increases the time taken for INSERT and UPDATE operations, especially if many indexes exist.
  3. Final Answer:

    Each index must be updated, increasing the time required for the operation -> Option A
  4. Quick Check:

    Indexes slow down writes due to maintenance overhead [OK]
Quick Trick: More indexes mean more overhead on writes [OK]
Common Mistakes:
  • Assuming indexes speed up all operations
  • Believing indexes only affect SELECT queries
  • Thinking indexes reduce update time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes