Re: fastest SQL?

From: Kellyn <kjped1313_at_yahoo.com>
Date: Fri, 12 Mar 2010 19:07:15 +0000
Message-ID: 1919898531-1268420820-cardhu_decombobulator_blackberry.rim.net-1056745273-_at_bda339.bisx.prod.on.blackberry>

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 Received on Fri Mar 12 2010 - 13:07:15 CST