Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g ORDER BY Performance

Re: 10g ORDER BY Performance

From: goran bogdanovic <goran00_at_gmail.com>
Date: Tue, 28 Aug 2007 13:55:26 +0200
Message-ID: <6d0a3ba80708280455u763d09b9m48e3091c57544b8c@mail.gmail.com>


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-l
Received on Tue Aug 28 2007 - 06:55:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US