Get the MySQL Execution Plan Quick Reference Guide
This PDF guide contains:
- a list of the common access methods, join operations, and sort operations that you see in a MySQL Execution Plan
- a definition of each term
- an explanation of when they would be used
Use this list to understand what the Execution Plan or Explain Plan is showing you and as a first step to improving your query performance.