If you do not have an index, won't you need to do a
sequential scan of the full table each time. With 6m
entries, it could take a while.

Cheers,
Ken
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 ?
>
> Ist required , can I drop 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

Reply via email to