Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: benchmarking, which statement is faster

Re: benchmarking, which statement is faster

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Thu, 26 Jul 2001 20:13:42 +0100
Message-ID: <oUZ77.5585$vN4.22100@news11-gui.server.ntli.net>

I entirely agree with you. It was just that one of the posts asked for a case where an explicit cursor was faster, and I love a challenge. As I said, the example I gave was not a realistic situation at all.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:996146373.6141.0.nnrp-14.9e984b29_at_news.demon.co.uk...
>
> Very good point, and worth raising.
> However, there is an argument that says:
>
> a) You don't care if there are too many rows,
> so you should include 'and rownum = 1'
> in the implicit version to avoid the problem
> whilst making a clear statement of intent
>
> or conversely
>
> b) You do care if there is more than one row
> in which case your explicit version would
> have to do the explicit second fetch anyway,
> leaving you with the same cost as the automatic
> second fetch on the implicit cursor.
>
Received on Thu Jul 26 2001 - 14:13:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US