Tuesday, July 4, 2017
PLSQL Performance Tuning – Implicit VS Explicit Cursors
In
this post, I tried to understand the difference what Implicit and explicit
cursors can make on PLSQL performance. Which is better?
Here
is the small demonstration to show “Implicit Cursors” are definitely better
than Explicit cursors. As much as possible, it’s better to use Implicit
Cursors.
Demonstration:
The time consumed clearly shows that “Implicit Cursor” is a winner from Performance perspective. Here, the time difference is because of the number of lines of source code. As PLSQL is interpreted code, this number of lines makes a difference.
Hope it helps!!
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
Disclaimer
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.
0 Responses to “PLSQL Performance Tuning – Implicit VS Explicit Cursors”
Post a Comment