EXPLAIN
Learn EXPLAIN (Query Optimization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction EXPLAIN shows the execution plan the optimizer chose for a statement without running it: which tables are read, in which order, with which access type and index, and how many rows it expects to examine.