Re: 10gR2 Upgrade .. Watch out

From: "Jared Still" <jkstill@xxxxxxxxx>
To: gkatteri@xxxxxxxxxxx
Date: Thu, 28 Dec 2006 11:36:55 -0800

On 12/27/06, GovindanK <gkatteri@xxxxxxxxxxx> wrote:


  In an earlier posting , Juan Carlos had mentioned about having problem with "union 
all"; We encountered the following after upgrading to 10gR2. Thought i will share 
this with the list.

1. Group by was not doing the sort in the default order where as 9.2.0.6 / 9i 
Rel2 was doing so

This behavior has been documented for many years.

GROUP BY has never guaranteed SORT order, and likely never will.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Follow-Ups:

Re: 10gR2 Upgrade .. Watch out
From: rjamya

References:
- Performance issues after 10gR2 Upgrade.
  - From: MVR
- Re: Performance issues after 10gR2 Upgrade.
  - From: John Kanagaraj
- 10gR2 Upgrade .. Watch out
  - From: GovindanK

Other related posts:

Browse oracle-l