- Each time you fetch a row from the cursor, it results in a network roundtrip.
- Cursors are also costly because they require more resources and temporary storage (results in more IO operations).
- Further, there are restrictions on the SELECT statements that can be used with some types of cursors.
Disadvantages of cursors
