MySQL < 5.0 can only use 1 index per table.
MySQL >= 5.0 can use more than one via an index merge.
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html
On Sat, Sep 27, 2008 at 2:47 AM, Micah Gersten <[EMAIL PROTECTED]> wrote:
> MySQL queries use 1 index per table, so to speed the
ces.
Can you help out rewriting the query using EXISTS syntax?
Thanks in advance,
Yves
- Original Message -
From: "Micah Gersten" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 26, 2008 11:47 AM
Subject: Re: [PHP-DB] query optimization - DB
MySQL queries use 1 in
MySQL queries use 1 index per table, so to speed the query, we need to
know what indices you have for the 2 tables.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Yves Sucaet wrote:
> Oh, sorry I forgot to mention this. It's a MySQL database.
>
> - Origi
Oh, sorry I forgot to mention this. It's a MySQL database.
- Original Message -
From: "Micah Gersten" <[EMAIL PROTECTED]>
To: "YVES SUCAET" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, September 25, 2008 7:55 PM
Subject: Re: [PHP-DB] query optimization
Other question is, what DB is this
