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.