 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
• |
EXPLAIN SELECT (continued)
|
|
|
|
– |
Type (continued)
|
|
|
|
• |
eq_ref
|
|
|
|
– |
One row matches per combination
|
|
|
|
– |
Unique index match
|
|
|
|
• |
ref
|
|
|
|
– |
Several matching rows per combination
|
|
|
– |
Non-unique index
|
|
|
|
• |
range
|
|
|
|
– |
A range of rows will be retrieved
|
|
|
|
• |
index
|
|
|
|
– |
Index will be scanned for matches
|
|
|
|
– |
Like a table scan, but faster
|
|
|
|
• |
all
|
|
|
|
– |
Full table scan
|
|
|
|
– |
Worst case
|
|