Re: fastest SQL?
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 11 Mar 2010 21:34:07 +0100
Message-Id: <974C5125-1F87-4663-8932-5D20FAC5237A_at_gmail.com>
How fast is it on your fastest DB?
I don't want to set boundaries. ok, let's talk about an Oracle RDBMS. any Version. any OS. any SQL. just show your timing.
Date: Thu, 11 Mar 2010 21:34:07 +0100
Message-Id: <974C5125-1F87-4663-8932-5D20FAC5237A_at_gmail.com>
How fast is it on your fastest DB?
I don't want to set boundaries. ok, let's talk about an Oracle RDBMS. any Version. any OS. any SQL. just show your timing.
I _assume_, the 1st 'select 1 from dual;' is slightly slower as the
2nd one (hard/soft parsing).
Any method to make it even faster?
Am 11.03.2010 um 21:30 schrieb Niall Litchfield:
> select 1 from dual; is pretty fast. perhaps you'd like to set some
> boundaries.
>
> On Thu, Mar 11, 2010 at 8:20 PM, Martin Berger <martin.a.berger_at_gmail.com
> > 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. ;-)
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 11 2010 - 14:34:07 CST