RE: fastest SQL?
- From: "Storey, Robert \(DCSO\)" <RStorey@xxxxxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <martin.a.berger@xxxxxxxxx>
- Date: Thu, 11 Mar 2010 14:41:36 -0600
Guess I'm missing something?
Are you asking whats the fastest query that can be written based on
building the fastest possible hardware base, oracle version, etc?
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, March 11, 2010 2:37 PM
To: martin.a.berger@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: fastest SQL?
On Thu, Mar 11, 2010 at 12:20 PM, Martin Berger
<martin.a.berger@xxxxxxxxx> wrote:
what is the fastest SQL you can create?
Looks like a commit without a transaction is pretty fast. ;)
12:35:15 SQL> select dummy from dual;
D
-
X
1 row selected.
Elapsed: 00:00:00.10
12:35:22 SQL> commit;
Commit complete.
Elapsed: 00:00:00.00
12:35:27 SQL> rollback;
Rollback complete.
Elapsed: 00:00:00.03
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
