RE: 10gR2 Upgrade .. Watch out

>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

Other related posts: