What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 11158 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul kumar
A) In cursors each time you fetch a new row it does a round
trip with the database thereby increase network use and time.
B) There is also restriction on select statements that can be
used in cursors
C) It also uses more resources and temporary memory
Cursors can be avoided with the help of careful
implementation of while loop and other set based operations
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
