>>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.
The number of records returned on those queries is quite small. It doesn't exceed 400 records.
>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.
Do you think the NOFILTER could have a benefit here?