[drupal-devel] MySQL indices not being picked up

[Dries Buytaert]

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/