Question · SQL and MySQL course · Module 9: Indexes and normalization

The cost of indexes

What is the main cost of creating many indexes?

Answer options

  • They slow down write operations (INSERT, UPDATE, DELETE) and take up extra space
  • They cause SELECT to stop working
  • They remove the primary key from the table
  • They change the column names in the table

You can check the correct answer by solving this task in the CodeWorlds game.