Re: 10gR2 Upgrade .. Watch out

Unless you specify ORDER BY, the order of the result set will depend on the operation AND the execution plan. If the CBO decides to use a different index, you might get a different order to the result set without changing anything else.
Oracle changes defaults (among many other things) from release to release, so you can NEVER depend on them for specific functionality. And you can't hold Oracle accountable when things change. 

Regards,
Daniel Fink


GovindanK wrote:

In 9iRel2 (irrespective of what the manual used to say) the order by was
taking place.. if the manual says it does not guarantee,  it should not
then sort it every time and produce the result .. yes i agree that
unless "order by" is mentioned it should not sort .. but the 9iRel2
optimizer was doing it (so too 10.1.0) .. this was not happening with
10.2.0 ..

 Remember one thing .. if the manual says the same for 9.2 and 10.2 as
 you had mentioned . the default behaviour should not change across
 upgrades .. correct ..  BUT that is not the case..
Hope this clarifies..


--
http://www.freelists.org/webpage/oracle-l

Other related posts: