SQL EXPLAIN: Index-related columns
These relate to the usage of indexes:
- Which indexes were considered?
- Which indexes did the optimizer choose?
- How many bytes of the index will be used?
SQL EXPLAIN: The “type” column
The “type” column indicates how MySQL will access rows
From worse to better: