RE: 10gR2 Upgrade .. Watch out
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 16:27:02 -0800
>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:
