[rt-devel] Slow Queries part3, Groups

[Robert Spier]

At Wed, 08 Oct 2003 13:41:53 +0800,
Matthew Watson wrote:
> Yep, i've got those indexes,

I wonder why Mysql isn't picking them up.  If you get a chance to
create the Domain index, or maybe (Domain,Instance) and run an EXPLAIN
on it, 

> Server version:         4.0.15a-standard-log

Hmm.  Some older (4.0.12 era) MySQL had some issues with picking the
right index, but those were fixed.

The Groups1 index _should_ be right for that query.  I'm not sure why
it's not getting picked up.

-R