A m Z o n e

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).

Press the Back button of you Browser to go to previous page
Home