Re: fastest SQL?
- From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Thu, 11 Mar 2010 13:41:32 -0700
On my 11gR2 on AIX 6.1:
*SQL> set timing on
SQL> select 1 from dual;
1
----------
1
Elapsed: 00:00:00.00
SQL>*
So it's hard to beat that. Even my 11gR2 on Solaris 10 (x86-64):
*sys@RNRPS> set timing on
sys@RNRPS> select 1 from dual;
1
----------
1
1 row selected.
Elapsed: 00:00:00.01
sys@RNRPS>*
It's pretty darn fast.
- References:
- fastest SQL?
- From: Martin Berger
- Re: fastest SQL?
- From: Jared Still
- fastest SQL?
Other related posts:
- » fastest SQL? - Martin Berger
- » Re: fastest SQL? - Niall Litchfield
- » Re: fastest SQL? - Martin Berger
- » Re: fastest SQL? - Jared Still
- » Re: fastest SQL? - Toon Koppelaars
- » Re: fastest SQL? - Kevin Lidh
- » RE: fastest SQL? - Storey, Robert \(DCSO\)
- » Re: fastest SQL? - Andre van Winssen
- » RE: fastest SQL? - Don Granaman
- » Re: fastest SQL? - Martin Berger
- » Re: fastest SQL? - Martin Berger
- » Re: fastest SQL? - japplewhite
- » RE: fastest SQL? - Allen, Brandon
- » RE: fastest SQL? - Allen, Brandon
- » RE: fastest SQL? - Christopher Boyle
- » Re: fastest SQL? - Niall Litchfield
- » Re: fastest SQL? - John Piwowar
- » Re: fastest SQL? - Jason Heinrich
- » RE: fastest SQL? - japplewhite
- » RE: fastest SQL? - Don Granaman
- » Re: fastest SQL? - Daniel Fink
- » Re: fastest SQL? - Robert Freeman
- » Re: fastest SQL? - Daniel Fink
- » Re: fastest SQL? - troach
- » Re: fastest SQL? - Grant Allen
- » Re: fastest SQL? - Martin Berger
- » Re: fastest SQL? - Martin Berger
- » RE: fastest SQL? - Dunbar, Norman
- » Re: fastest SQL? - Jaromir D.B. Nemec
- » Re: fastest SQL? - Job Miller
- » Re: fastest SQL? - Kellyn
- » Re: fastest SQL? - kathy duret
- » Re: fastest SQL? - Robert Freeman
- » Re: fastest SQL? - Daniel Fink