Wow, now that's the first time I've heard this point of view. It seems most everyone has been preaching about the benefits of the deleted tag for quite a while. . . -Rick

>...If you repeat with SET DELETED ON, each query that was fully optimized will now show as partially optimized but the times are the same. It is usually better performance-wise to not create a DELETED() tag, even though it will cause the query to be only partially optimized if SET DELETED is ON.