What are the disadvantages of cursors?

 Updated on October 27, 2014     VIKRAM     1160

Disadvantages of cursors

  • Uses more resources because each time you fetch a row from the cursor, it results in a network roundtrip.
  • There are restrictions on the SELECT statements that can be used. 
  • Because of the round trips, performance and speed is slow.

If you enjoyed this post, please like (or) share this article.