Re: [drupal-devel] MySQL indices not being picked up

Hi Daniel,

So, the order you define the index in is important. One must to take into consideration how the index will be used. If two columns in the index are subjects of frequent queries, but the second column sometimes not used in conjunction with the first, a separate index comprised of that column alone should be considered.

I hope my explanation is clear. Perhaps you already knew this. Is that the issue here?

Turns out that solved part of the problem. I didn't knew the order of muti-column indices was important. Thanks for the clear explanation. If only people like you could help tune Drupal's SQL queries. ;-) -- Dries Buytaert :: http://www.buytaert.net/