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


Yes, that could cause your problem. You should never fill a disk more that 80%, to guard against weirdness. Are your working files on the server or workstations(set in the config.fpw)? If the are on the server, make sure there is physically enough contiguous space to hold the queries. Also, it can be faster to have the workfiles sent to the workstation, depending on how your server component is running.

I assume that each of the fields being joined and/or filtered on are indexed (including deleted). If not, that may also help.

Also, you said something to the effect that you don't like the idea of breaking up the query into multiple subqueries, because it is inelegant. I agree with you. However, an inelegant application that runs is still more functional than an elegant application that doesn't...