Re: SQL TUNING - Does it make a difference, really?

In <4ps40n$srv_at_nr1.vancouver.istar.net> djetz_at_spots.ab.ca (Doris Jetz) writes:
>I have read in a couple differency oracle tuning books that using
>explicit cursors will save time if used in place of implicit cursors.
 

>Will this save a significant amount of time over the extent of the
>application?

I'm certainly no expert at Oracle but I just attended the Calgary meeting of the Oracle User Group. In one of the seminars a fellow discussed this very topic. He basically said that an implicit cursor requires two database accesses (one for the cursor and one for what the cursor's pointing at) for each use, while an explicit one requires only one.

-- 
Erwin Fritz  (erwin_at_fritz.cuug.ab.ca)

Backward slashes are for backward operating systems!