SQL Server Cursors Question: Download MS SQL Server Cursors PDF
Explain the disadvantages of cursors?
Answer:
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
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
| Previous Question | Next Question |
| Can you explain the disadvantages/limitation of the cursor? | How to avoid cursors? |