RE: 10g ORDER BY Performance (doh!)

Sorry. I see from the original post this is NOT specifically about GROUP BY without sorts. For the set of scripts that do have GROUP BY, either the setting or the previously suggested automated script edit should work.

For scripts with neither a group by nor an order by it is difficult to create a solution without making presumptions about the desired order and the order the data was originally inserted into the tables as well as any intervening deletes followed by inserts as well as updates involving the columns involved in the former coincidental ordering of the result sets.

Now possibly you could get back to sloppy acceptability and previous behavior by setting both those parameters previously referenced in the thread as well as manually setting your hash area parameter to an absurdly small size. But otherwise, see Tanel's note.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Barnett
Sent: Friday, August 24, 2007 1:49 PM
To: Oracle-l
Subject: Re: 10g ORDER BY Performance

We already have that set for another problem and still have the unordered sort issue.

This is really a coding issue but we dno't have time to fix it.

• Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

<snip>

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