Re: 10g ORDER BY Performance

From: Peter Barnett <regdba_at_yahoo.com>
Date: Fri, 24 Aug 2007 10:48:38 -0700 (PDT)
Message-ID: <251.85393.qm@web31605.mail.mud.yahoo.com>

We already have that set for another problem and still have the unordered sort issue.

This is really a coding issue but we dno't have time to fix it.

• 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;
> >
>

Pete Barnett        

---

Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 24 2007 - 12:48:38 CDT