[rt-users] DisGrouMem index

[Jesse Vincent]

On Wed, Apr 14, 2010 at 02:17:10PM +0100, Raed El-Hames wrote:
> Hi;
> 
> rt-3.8.7
> mysql 5.1
> 
> Is the index  DisGrouMem (GroupId,MemberId,Disabled) required for 3.8
> 
> When I did:
> select * from CachedGroupMembers where Disabled = 1;
> I got back 232 rows out of 5594612
> 
> Which in my opinion makes that index useless ?

My recollection is that MySQL can do just fine using the first component of a compound index.

> Ist required , can I drop it??

I wouldn't recommend it.

> 
> Regards;
> Roy
> 
> 
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com

--