Re: 10gR2 Upgrade .. Watch out

On 12/27/2006 07:27:02 PM, GovindanK wrote:
>
> >hash aggregation - if you have code that gets the data in
> >the right order after doing a group by without an order
> >by, you may now find the data coming out in the wrong
> >order because oracle has switch to "hash group by"
> >instead of "sort group by". Add order by clauses -
> >or disable hash aggregation by setting
> > _gby_hash_aggregation_enabled = false
>
> 'Group By' Does Not Sort If You Don'T Use Order By In 10g
>
> Note:345048.1
>

Yes, there is a new thing called "HASH GROUP BY" which seems faster to me, but I'm unable to come up with a proper benchmark. That is probably something Jonathan could prove or disprove.

-- 
Mladen Gogala
http://www.mladen-gogala.com

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