> Most probably, 4.1 gens good plan for this. It just occurred to me that this seems to have started since I added the extra indexes for the Shredder - is that possible? It is actually possible to have "conflicting" indexes? Here are the indexes I added:
CREATE INDEX SHRD_CGM1 ON CachedGroupMembers(MemberId, GroupId, Disabled); CREATE INDEX SHRD_CGM2 ON CachedGroupMembers(ImmediateParentId, MemberId); CREATE UNIQUE INDEX SHRD_GM1 ON GroupMembers(MemberId, GroupId); CREATE INDEX SHRD_TXN1 ON Transactions(ReferenceType, OldReference); CREATE INDEX SHRD_TXN2 ON Transactions(ReferenceType, NewReference); CREATE INDEX SHRD_TXN3 ON Transactions(Type, OldValue); CREATE INDEX SHRD_TXN4 ON Transactions(Type, NewValue); -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users 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
