Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: benchmarking, which statement is faster
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