Re: Temp space vs. table size

I would seriously look at the query. Doing a join on 72 fields on an 800 meg table could be very slow. I'm guessing that you need such large sort area because you don't have your "order by" or join fields indexed.

Another approach might be to break up the query into sub-queries with range selects. Then use a Union to bring them together.

Also don't be afraid to create temporary tables to store intermediate steps. As you get data to step 3 of your query, you can truncate the tables used in step 2, and so on.

Without know the particulars of your environment, this is the best I can do.

--Bob. Received on Fri Dec 26 1997 - 00:00:00 CST