Hi Bruce,
>But my point, at least, is that the wisdom that it's a gospel rule (at least I had been led to believe this) to have a deleted index on any large table is not true. My largest tables (500 MB or so) have mostly single table, NOFILTER queries on them, and contain no deleted records. This is the situation where a deleted index makes no sense, so far as I can see...
Right. But when I read this thread I got the impression that the new rule is: "Never add an index on DELETED() unless you find in tests that it improves performances significantly." I think, the rule should be "Always add an index on DELETED() unless you find in tests that this index slows down your application (significantly)".
Christof
--
Christof