Question · SQL and MySQL course · Module 9: Indexes and normalization
What EXPLAIN is for
What is the EXPLAIN command before a SELECT query used for?
Answer options
- It runs the query twice as fast
- It translates the SQL query into plain English
- It automatically creates missing indexes
- It shows the query execution plan - including whether MySQL will use an index or scan the whole table
You can check the correct answer by solving this task in the CodeWorlds game.