A

Admin • 831.35K Points
Coach

Q. What does the EXPLAIN statement provide when used before a SELECT query?

  • (A) The result set of the query
  • (B) A human-readable execution plan showing how MySQL will execute the query
  • (C) Automatically optimizes the query and creates indexes
  • (D) Deletes the query cache
  • Correct Answer - Option(B)
  • Views: 9
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
EXPLAIN shows the query execution plan (table access order, possible indexes, join types). It does not run the query to return results, nor does it automatically optimize or create indexes. It does not delete the query cache.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.