Subject Temp Sort Area
Author ruan_h

I've got a couple of questions about the temp sort area setup. I'd
really appreciate any help.

1. If within a query that's going to return a large number of records,
there's more than 1 SORT, will the temp space be released immediately
after each sort operation, or will each sort require its own temp
space and release it all together at the end of transaction?

2. How to estimate the size of the temp area needed to do a SORT query
? I ran a query with GROUP BY, the raw set (before group) is about
0.5G, but I noticed that the temp space being used is about 4G in
order to do the GROUP BY.