Re: 10g ORDER BY Performance
- From: "goran bogdanovic" <goran00@xxxxxxxxx>
- To: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- Date: Tue, 28 Aug 2007 13:55:26 +0200
the parameter "_gby_hash_aggregation_enabled" is related to case where
'group by' in query (without 'order by' clause) was returning ordered data
in 9i using one method and in 10g is using another...the group by clause in
10g is enhanced to allow a hash algorithm to be used instead of sorting
algorithm to group the data.
On 8/24/07, Ghassan Salem <salem.ghassan@xxxxxxxxx> wrote:
>
> It's not the new sort that doing this, it's the 'hash group by'
> try disabling it using
> alter ... set "_gby_hash_aggregation_enabled"=false;
>
>
> On 8/24/07, goran bogdanovic <goran00@xxxxxxxxx> wrote:
> >
> > http://jonathanlewis.wordpress.com/2007/06/03/sorting/
> >
> > you may set it for a session too:
> >
> > alter session set "_newsort_enabled"=false;
> >
>
>
Other related posts:
