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
