> Chris wrote: >> Mysql will actually only use one index per table. I was surprised to >> find this out but it's mentioned in >> http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/dp/0596003064/ >> - page 64 (just looked it up to include a page ref). >> >> No idea if this is mentioned anywhere on the mysql site (doubt it). A friend at Mysql just sent me this. It is the portion of the mysql docs which discusses the new index optimization in 5.x and later. http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php