In general, it is a good practice to have a tag on deleted() records.. There are times when this rule, like any rule, should be left at the door...
>>It basically is an internal set filter to On !Deleted(). If you don't have a
>>deleted tag, and you have set filter on, your queries are never totally
>>optimized. Other things take a hit as well. This is why it is a good practice
>>to have a deleted tag...
>
>John, I always thought this, but it's been pointed out by several people, with numbers to back it up, that this is not necessarily a good thing. I've seen numbers showing the exact same query times with and without a deleted tag, one query reporting partial and one full optimization. The good practice is to check your query times and optimize your indexes for speed, rather than relying on SYS(3054).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only