In mysql what is the purpose of the sql explain statement

MCQ Answer

In MySQL, what is the purpose of the SQL EXPLAIN statement?

Topic : Database Fundamentals

A. Provides information about the execution plan of a query

B. Exports data from a table

C. Adds explanatory comments to a query

D. Lists all foreign keys in a database

Correct Answer is :

A. Provides information about the execution plan of a query