Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100189 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
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 ? | 10 Yes | 2 No |
Post New Answer View All Answers
What are the differences between stored procedure and the dynamic sql?
how can u get last observation in an unknown dataset ?
What are secondary xml indexes?
Explain about service Broker functions?
 Explain what is sql override for a source taLle in a mapping?
How to loop through the result set with @@fetch_status?
How to use subqueries with the exists operators in ms sql server?
Define right outer join?
Difference between Logical Page and Physical Page in SSRS.
Explain a differential backup?
What is SQL Azure Data sync?
How do we know if any query is retrieving a large amount of data or very little data?
When is update_statistics command used?
What are the options which must be set to allow the usage of optimistic models?
What are different types of raid configurations? : SQL Server Architecture
