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
--
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
