status, date_added);我写了以下两个查询,上面的两个索引可以完全满足这两个查询,但MySQL将where放在额外的列中。mysql> EXPLAIN SELECT cat_id FROM articles USE INDEX (cat_list_INX) WHERE cat_id=158 AND status=2 ORDER------+---------------+-----------
我正在读“高性能MySQL",O‘’Reilly,第二版。第122页:
EXPLAIN SELECT * FROM products JOIN ( SELECTSEAN CARREY' AND title LIKE '%APOLLO%' ) AS t1 ON (t1.prod_id=products.prod_id)\G