EXPLAIN table_name EXPLAIN select_query
The select_query is the same as specified in the SELECT description.
Using EXPLAIN with a table name is a synonym for DESCRIBE table_name. Using EXPLAIN with a query provides feedback about how the query will be executed, which is useful for optimizing the query and making the best use of the associated indexes.