This content has been marked as final. Show 3 replies
This is one of the 'features' of 10g. aggregation functions (group by , distinct etc) are faster at 10g - but the downside is the results dont come back in order. This optimization can be disabled if you want to revert to 9i behaviour.
gbyhash_aggregation=false (from memory not 100% sure).
As with any _ paramter you should check with oracle support before setting it.