Writing Fast Queries
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
Copyright 2003, Jeremy Zawodny