$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #19

What is the main trade-off of adding an index to a table?

  1. Faster reads, slower writes
  2. Stronger locks, fewer deadlocks
  3. Less disk space, slower reads
  4. Faster writes, slower reads
An index speeds up lookups, but every INSERT, UPDATE and DELETE must also maintain it and it takes space.
Play SQL & Databases ▸