Advantages and Disadvantages of Cursor?
Answer Posted / sarat
Cursors allow row-by-row processing of the resultsets.
Disadvantages of cursors: Each time you fetch a row from the
cursor, it results in a network roundtrip, where as a normal
SELECT query makes only one rowundtrip, however large the
resultset is. 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.
Most of the times, set based operations can be used instead
of cursors.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is a self join in sql server?
What are the five major components of a dbms?
What are various aggregate functions that are available?
What is check constraint in sql server?
What are null values in ms sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is the use of “join” in sql server?
What is the purpose of self join?
What do you mean by a Composite primary key?
Mention a few common trace flags used with sql server?
Which are new data types introduced in sql server 2008?
What is updatable resultset?
What is the difference between varchar and nvarchar datatypes?
What is dbcc? Give few examples.
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?