What is a Cursor? Why to avoid them?

 A database Cursor is a control which enables traversal/ iteration over the rows or records in the table.

5 step process:

  • Declare
  • Open
  • Fetch using while loop
  • Close
  • Deallocate


LIMITATION

A cursor is a MEMORY resident set of pointers. Meaning it occupies lots of memory from your system which is not good for performance.

 


Post a Comment

Previous Post Next Post