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.