The detailed set of steps MySQL’s optimiser chooses to execute a query, including which indexes to use, join order, and access methods. Viewed with EXPLAIN or EXPLAIN ANALYZE. SQLyog’s visual EXPLAIN tool makes plans easy to read.
