Re: fastest SQL?

From: kathy duret <katpopins21_at_yahoo.com>
Date: Fri, 12 Mar 2010 11:31:44 -0800 (PST)
Message-ID: <644641.11927.qm_at_web38201.mail.mud.yahoo.com>

Hey!
 

Jared will tell you that is my line to tell people on the list to get a life!
 

Back to point - fastest sql is the one I don't have to touch!
 

Happy Friday!
 

K

• On Fri, 3/12/10, Kellyn <kjped1313_at_yahoo.com> wrote:

From: Kellyn <kjped1313_at_yahoo.com>
Subject: Re: fastest SQL?
To: jobmiller_at_yahoo.com, martin.a.berger_at_gmail.com, "ORACLE-L" <oracle-l_at_freelists.org>, jaromir_at_db-nemec.com Date: Friday, March 12, 2010, 1:07 PM

I think y'all need a hobby- and one that doesn't include oracle!  -Kellyn ------Original Message------
From: Job Miller
Sender: oracle-l-bounce_at_freelists.org

To: martin.a.berger_at_gmail.com
To: ORACLE-L
To: jaromir_at_db-nemec.com

ReplyTo: jobmiller_at_yahoo.com
Subject: Re: fastest SQL?
Sent: Mar 12, 2010 7:44 AM

This whole threads sounds like a trick interview question for a DBA.

Q: You are presented a really slow SQL statement, what do you do, or how do you tune the SQL statement to make it really fast?

You look at the statement/business logic and decide that you don't need to run that statement at all.  Jaromir gets my vote.

     

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




Sent via BlackBerry from T-Mobile

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





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

Received on Fri Mar 12 2010 - 13:31:44 CST