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 2002, Jeremy Zawodny (Jeremy@Zawodny.com)