Re: fastest SQL?

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Fri, 12 Mar 2010 14:10:15 -0800 (PST)
Message-ID: <918007.14167.qm_at_web113211.mail.gq1.yahoo.com>

I got me too many of those already!! :)

 Robert G. Freeman
Master Principle Consultant, Oracle Corporation Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com

---

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

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 - 16:10:15 CST