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

The type column in the plan

In an EXPLAIN plan, what does a type value of ALL mean?

Answer options

  • The query used the best possible index
  • The query will return all columns
  • A full table scan - the database goes through every row, no index was used
  • The table is empty

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