Re: Minimize Performance Hit on Sort...Help!

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Mon, 8 Feb 2010 09:11:58 -0800 (PST)
Message-ID: <680704.82283.qm_at_web32007.mail.mud.yahoo.com>

Oh Adar, you are sooooo preaching to the choir here... :)  As a follow up, we rewrote the query completely and then I was able to convince them that sorting 1.3TB of data in Oracle was NOT a good idea.  They are about to move the SAS servers from Windows to Linux, (yes, this was part of the reason to perform the sort on the database instead of in SAS...) and once they move over in the next month, they will be sorting on the SAS side, one way or the other.  DBA said enough is enough, I don't care WHAT claims the last DBA's made... :)

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com
 
"Go away before I replace you with a very small and efficient shell script..."

• On Sun, 2/7/10, Yechiel Adar <adar666_at_inter.net.il> wrote:

From: Yechiel Adar <adar666_at_inter.net.il> Subject: Re: Minimize Performance Hit on Sort...Help! To: kjped1313_at_yahoo.com
Cc: "oracle Freelists" <oracle-l_at_freelists.org> Date: Sunday, February 7, 2010, 11:07 PM

Remove the order by and tell them to sort the data in SAS. Adar Yechiel
Rechovot, Israel

Kellyn Pedersen wrote:

IQuery with a order by that MUST be done in Oracle as the file is an output to a dataset in SAS.

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

Received on Mon Feb 08 2010 - 11:11:58 CST