Intermediate
SQL
Q64 / 100
What is the purpose of "EXPLAIN" (or "EXPLAIN PLAN") before a query?
Correct! Well done.
Incorrect.
The correct answer is B) It shows the execution plan the database engine would use to run the query, such as which indexes are used, helping with performance tuning
B
Correct Answer
It shows the execution plan the database engine would use to run the query, such as which indexes are used, helping with performance tuning
Explanation
EXPLAIN reveals how the database planner intends to execute a query (table scans vs index usage, join order, estimated costs), guiding optimization efforts.
Progress
64/100