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