Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g ORDER BY Performance
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_at_gmail.com> 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_at_gmail.com> wrote:
> >
> > http://jonathanlewis.wordpress.com/2007/06/03/sorting/
> >
> > you may set it for a session too:
> >
> > alter session set "_newsort_enabled"=false;
> >
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 28 2007 - 06:55:26 CDT
![]() |
![]() |