>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 ?
>
I can make an experiment, but in the final result I need only non-deleted records, so I will need set deleted on anyway.

>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,


Don't think, it would help. Actually, I think there was another problem there, which I didn't remember at the time, I wrote this message. When I connected our server through PCAnywhere, I got a message, that the server is running out of space. I ignored it and continued my work, but it might be a reason for such slowness.