RE: More help on sort

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 10 Nov 2000 09:32:50 +1000
Message-Id: <10675.121660@fatcity.com>

Hello Shivaswamy,

Yes, you can COMPUTE statistics and then use EXPLAIN PLAN to get the cost of the query for different 'sort_area_size' settings. However, the only differences that you'll notice are the effect of avoiding a disk sort altogether if your 'sort_area_size' is big enough, and the effect of needing multiple merge phases if your 'sort_area_size' is very small. Otherwise, the effect of 'sort_area_size' on an individual query is almost nil.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Raghunath, Shivaswamy [mailto:Shivaswamy.Raghunath_at_qwest.com] Sent: Friday, 10 November 2000 7:46
To: Multiple recipients of list ORACLE-L Subject: More help on sort

Is it possible to play what-if with 'sort_area_size' for a given query performence? I mean, other conditions being equal what is the effect of different settings of 'sort_area_size' on query performence? Received on Thu Nov 09 2000 - 17:32:50 CST