Question
EXPLAIN versus execution-aware plan analysis: what differs, and when should each be used?
Answer
EXPLAIN reports the optimizer’s intended access plan and estimates. Execution-aware analysis runs the statement and reports observed work; use it on representative, safe workloads to test estimate accuracy. Applies to MySQL and MariaDB.