SQL Server Cursors Question: Download MS SQL Server Cursors PDF
Do you know the cursor optimization tips?
Answer:
Close cursor when it is not required.
You shouldn’t forget to deallocate cursor after closing it.
You should fetch least number of records.
You should use FORWARD ONLY option when there is no need to update rows.
You shouldn’t forget to deallocate cursor after closing it.
You should fetch least number of records.
You should use FORWARD ONLY option when there is no need to update rows.
| Previous Question | Next Question |
| What is cursor in MS SQL Server? | Do you know the cursor types? |