Question · SQL and MySQL course · Module 9: Indexes and normalization
The key column in the plan
What does a NULL value in the key column of an EXPLAIN plan mean?
Answer options
- No index was used - the database must search the whole table
- The query contains a syntax error
- The primary key of the table has been removed
- The table has too many indexes
You can check the correct answer by solving this task in the CodeWorlds game.