SQL Execution Plan

Explain + SQL statement

The type types returned are

All full table scan (special with limit), type for this type, indicates that the table can be optimized

Index full Index Scan

Range Lookup for indexed columns

Index_merge merge indexes, using multiple single-column indexes

Ref finds one or more values based on an index

Eq_ref using primary KEY or unique type when connecting

CONST constant

system table has only one row and is a special case of const

SQL Execution Plan