Re: fastest SQL?
- From: troach@xxxxxxxxx
- To: daniel.fink@xxxxxxxxxxxxxx,"Robert Freeman" <robertgfreeman@xxxxxxxxx>
- Date: Fri, 12 Mar 2010 02:35:10 +0000
I see your point, but if there was no sql statement then how can it be the
fastest sql statement?
That's like saying the fastest 100 meter dash is the one who doesn't run one,
but then it's not a 100 meter dash :)
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
Date: Thu, 11 Mar 2010 18:41:32
To: Robert Freeman<robertgfreeman@xxxxxxxxx>
Cc: Oracle-L Freelists<oracle-l@xxxxxxxxxxxxx>
Subject: Re: fastest SQL?
Ah....but does this not prove my point.
There was no sql statement whatsoever in my reply!
Daniel Fink
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
Robert Freeman wrote:
> Ahhhh, but is this so? Exit is not a SQL statement but rather a
> SQL*Plus command I believe. Correct? So, the exit command would not
> qualify.
>
> :)
>
> RF
>
>
> 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:* Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
> *To:* martin.a.berger@xxxxxxxxx
> *Cc:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Thu, March 11, 2010 5:40:09 PM
> *Subject:* Re: fastest SQL?
>
> The essence of Anjo Kolk's statement.
>
> SQL> exit
>
> The fastest sql is the one that is never run.
>
> Daniel Fink
>
> OptimalDBA http://www.optimaldba.com
> Oracle Blog http://optimaldba.blogspot.com
>
> Lost Data? http://www.ora600.be/
>
>
> Martin Berger wrote:
>> what is the fastest SQL you can create?
>>
>> this sounds silly at the first view, but maybe some of you want to
>> create a really fast SQL and show me how you made it that fast.
>> everything is allowed, (HW, SW, ...) just please share your methods!
>>
>> I hope you enjoy this challenge. ;-)
>>
>> Martin
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>
Other related posts:
