Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 101394 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
Explain the various types of concurrency problem?
what is normalization? Explain different levels of normalization? : Sql server database administration
what are isolation levels? : Sql server database administration
What do you mean by subquery?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What are the joins in sql server? : sql server database administration
What is sql injection? How to protect against sql injection attack?
Define cursor locking
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is trigger explain with program?
How do I run sql server 2014?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What options are available to audit login activity? : sql server security
what is checksum in sql server.........???
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
