Re: fastest SQL?

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 11 Mar 2010 12:36:32 -0800
Message-ID: <bf46381003111236t77cf1bf0g171d33d200e61de6_at_mail.gmail.com>

On Thu, Mar 11, 2010 at 12:20 PM, Martin Berger <martin.a.berger_at_gmail.com>  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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 11 2010 - 14:36:32 CST