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