>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