AW: Re: [rt-users] clean up user table

Gordon Messmer gmessmer at u.washington.edu
Tue Dec 4 13:58:03 EST 2007


Ruslan Zakirov wrote:
> I do believe index on GroupMembers(MemberId, GroupId) will help this 
> query much.

I missed this message somehow.  Do you think I should have used an index 
on GroupMembers(MemberId, GroupId) instead of just GroupMembers 
(GroupId)?  Or an additional index?  The distributed schema indexes 
CachedGroupMembers(MemberId) and CachedGroupMembers(GroupId) 
separately.  Should GroupMembers and CachedGroupMembers be indexed the 
same way?




More information about the rt-users mailing list