Re: PHP and MySQL design question
| From: | Roberto Mansfield | Date: | Fri, 02 Nov 2007 15:00:01 +0000 |
| Subject: | Re: PHP and MySQL design question | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44307@lists.php.net to get a copy of this message | ||
> 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/ß~)Òµ±
>> QQ¤"MíR
>> - 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