>We're working with SET DELETE ON, and I'm my book and from what I was told in several years, that we should have a tag on DELETED(). Unless, this has changed in the last versions. Isn't it the case? Any comment on that?
Michel, basically nothing has changed. If you have a tag on Deleted(), or on any other expression that returns many records for part of a condition, the query is fully optimized, and therefore slow.
A partially optimized query is sometimes much faster. Please try it!
Oh, BTW, I understand that sometimes a "fully optimized" query will run faster than a "partially optimized" query, but slower over a network. In this case, program for the worst-case scenario, i.e., network.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)