Hilmar-


>Remember, too, *not* to include any index on the expression deleted(); this will also return too many records.

I really enjoyed your very lucid discussion of optimization. Just a small quibble. If people have a filter on DELETED() on the PK index, then they should have an index on Deleted(). Which can cause the problems you point out.

All the more reason to use surrogate keys...one doesn't need the deleted() filter.