>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.


Hi Christof, let me make sure I understand this.

So if I have no need for Deleted() tag, and SET DELETE is off, but my app commonly runs SQL SELECT COUNT(*)... statements, then I should have a deleted() tag on those tables involved in COUNT SQL operations?