> > Keep in mind GROUP BY clause usually dictates index use. > The reason for this wasn't immediately apparent to me. The key thing to remember is that groupi

> > Keep in mind GROUP BY clause usually dictates index use. > The reason for this wasn't immediately apparent to me. The key thing to remember is that grouping is essentially a sorting operation, and it happens before your other sorts (that last part isn't necessarily as obvious).