EXPLAIN SELECT select_statement
Description: Provides the query plan for a SELECT. MySQL shows how it will join any tables and in which order.
This can enable you to see whether the query optimizer will join the tables in the optimal order. You can override this order using a SELECT with a STRAIGHT_JOIN clause.
Description in: Day 18
See also: SELECT and the STRAIGHT_JOIN clause
Get Sams Teach Yourself MySQL in 21 Days, Second Edition 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.