Hi Garrett,
>A short quote from an internal post which I'm currently re-working into a MSKB article:
Please add that COUNT TO and SELECT CNT() work completely on the index if the expression is fully optimized and therefore usually require the index on DELETED() for all tables involved and that this index should only be removed for these tables, when the negative impact otherwise is stronger.
Christof
--
Christof