🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.SELECT queries become slower
  2. B.INSERT, UPDATE and DELETE become slower and storage grows
  3. C.Primary keys stop working
  4. 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 →