Roy, The schema that came with RT 3.8.5 has the DisGrouMem index on CachedGroupMembers and not the GrouMem index. I would drop that latter index.
Regards, Ken On Wed, Apr 14, 2010 at 02:54:01PM +0100, Raed El-Hames wrote: > Jesse; > > Ah - In my database I do also have index GrouMem (GroupId,MemberId) on > CachedGroupMembers > Your reply prompted me to have a look at the source code and it seems for > one reason or another I may have created this index myself based on the > Oracle schema some time in the past few years. > > Considering there is (GroupId,MemberId) index, do you still recommend not > to drop the DisGrouMem index (what will be the reason)? > I will need to drop one of them and I inclined to drop the 3 element index > -- unless you tell me not to. > > Regards; > > Roy > > Jesse Vincent wrote: >> >> 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 > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
