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?
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today.
Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
