Re: benchmarking, which statement is faster

Daniel,

You may want to consider the possibility that your best information, and the information of your DBA group, goes out of date as time passes.

The sensible response to Tom's comments is to be sufficiently suspicious of your 'knowledge' to figure out a test which allows you to determine whether or not things have changed.

In fact it is very easy to show that implicit cursors are faster than explicit cursors on two counts - particularly when the target is a single row fetch.

1. Fewer recursive calls (factor of 3)
2. Lower CPU usage

As a further demonstration that the old
explicit/implicit argument is out of date, you will also find that the latch costs of the two strategies are the same.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.




Daniel A. Morgan wrote in message <3B5F1DB7.42F4A196_at_attws.com>...


>

>Beg to disagree here Tom. The day I find a developer at any company where I

 consult


>using anything other than explicit for pulling records in a loop they will

 not


>longer be on the project. And the other DBAs in my group agree.

>

>Daniel A. Morgan

>