A MySQL statement that shows the query execution plan — which indexes are used, how tables are joined, the estimated row count, and join type. EXPLAIN is the primary tool for diagnosing slow queries and verifying that indexes are being used correctly.
