Temp space vs. table size

I currently have 2 temp segments, one 40 and one 70 meg, 550 extents at 256K each percent increase set to 0. I keep running out of temp space while doing a non-grouping query on a very wide (72 fields), very long table. This table comes in at just under 800 meg. Is there some sort of desired ratio between temp space and your largest table? Thanks in advance,
derwoud_at_bellsouth.net Received on Thu Dec 04 1997 - 00:00:00 CST