[drupal-devel] MySQL indices not being picked up
dries at buytaert.net
Sun May 15 18:46:55 UTC 2005
> So, the order you define the index in is important. One must to take
> consideration how the index will be used. If two columns in the index
> subjects of frequent queries, but the second column sometimes not used
> 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
> 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/
More information about the drupal-devel