[rt-users] DisGrouMem index

[Kenneth Marshall]

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
>