← Quiz: Indexing: all 10 questions
Quiz: Indexing · Question 4 of 10
What is a downside of adding many indexes?
What is a downside of adding many indexes?
- A.SELECT queries become slower
- B.INSERT, UPDATE and DELETE become slower and storage grows
- C.Primary keys stop working
- D.Joins are no longer possible
Answer & explanation
Correct answer: INSERT, UPDATE and DELETE become slower and storage grows
Every write must also update each index.
Can you get the rest right without peeking?
Take the timed Quiz: Indexing quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →