Name
EXPLAIN
Synopsis
EXPLAIN {table
|SELECT...}
You can use this statement to display
information about the columns of a given table, or to display
information about the results set of a given
SELECT
statement without displaying the rows of
data. For this latter use, it will show which index the statement
will use and, when multiple tables are queried, the order in which
the tables are used. This can be helpful in determining the cause of
a slow query.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.