10g ORDER BY Performance
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: Oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Aug 2007 06:48:28 -0700 (PDT)
First, the disclaimer, someone made a very bad coding
decision! Now the question is how to get out of the
mess.
We have about 2,000 scripts that do not have ORDER BY
clauses anywhere in them. In 9i all of the queries
returned the rows in the correct order. More a lucky
accident than anything else.
In 10g the optimizer has changed and the results are
returned unordered. Since we are weeks away from go
live of a major project there is no time to edit and
test all of the scripts. Management is now wanting us
to go live on 9i rather than 10g. Something the DBA
team is really resisting but may be necessary.
I came across a _newsort_enabled parameter which did
not change the result set in 10g. Is anyone aware of
a parameter that can be set in 10g that will give the
9i behavior other than setting the
optimizer_features_enabled to 9.2? If we do that we
might as well be on 9i.
Pete Barnett
____________________________________________________________________________________
Choose the right car based on your needs. Check out Yahoo! Autos new Car
Finder tool.
http://autos.yahoo.com/carfinder/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
