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.