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

Other related posts: