Optimizing MySQL: Queries and Indexes
great article (oldie but goodie) — great table for reference best to worst query explanations: system, const, eq_ref, ref, range, index, all
