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.