Hi nadya

>Do you have suggestions to optimize it (don't suggest to drop deleted tags :))?

Of course, the DELETED() tags could be a cause of the slow SQL. Can you check performance with SET DELETE OFF ?

If performance is significantly better, I think there is no other way than to get rid of those tags.

You can also try to disable rushmore for this particular query.

Walter,