Hello Chris,
Wednesday, March 10, 2004, 12:48:02 AM, you wrote:
CF> Thanks for the email. I created a multi-field index using the fields that
CF> are in the query and the query only took 0.91 seconds. That's better than 9
CF> minutes and definitely under 30 seconds.
Glad to hear it.
Farewell MSS
Hello Chris,
Tuesday, March 9, 2004, 6:15:56 PM, you wrote:
CF> Why does it only use the one index?
It will evaluate the best index to use for the query and if all you
have are single-field indexes, it can only select one of those.
From the MySQL manual:
"If a multiple-column index exists on c