>Fred,
>
>My resultset was about 16.000 records and not the whole expression was rushmore optimizable.
I've seen result sets of ~ 40K records in less than 1 second. They do require full optimization for those kinds of speeds.
You're arguments about the DELETED tag not making a difference when the rest of the query is not optimized just don't tell us anything. If the DELETED tag made no difference when everthing else was optimized, then you'd have something. I've seen many instances where not having a tag on DELETED() made a hugh difference in time, like queries that took 2-3 minutes without the tag, and less than 3 seconds with it. My vote is for the tag.