Implicit Vs Explicit Cursors
"Implicit cursors run faster than explicit cursors. But in
situations where multiple users may execute the code concurrently, use
explicit cursors - they will be cached in memory in the shared sql area
and reused". You agree?
True. But in cases where you are retrieving only one record,
explicit cursors are faster compared to implicit cursors. Another way of
optimising your statement (if you hate explicit cursors) is by using rownum = 1 in
where clause (this should not be used incase you want to trap too-many-rows
exception).
This page was create on 15-dec-2000 and last updated on 15-dec-2000.
please forward all queries to amar_padhi@fastmail.fm