Re: 10g ORDER BY Performance

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