MySQL Performance Blog » Using index for ORDER BY vs restricting number of rows.
l> EXPLAIN SELECT * FROM goods force INDEX(cat_id) WHERE c
March 9, 2007 at 10:22:23 AM EST
*
FILLER
l> EXPLAIN SELECT * FROM goods force INDEX(cat_id) WHERE c