Advantages and Disadvantages of Cursor?
- 15 Answers
- 97861 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 ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the differences between char and varchar in ms sql server?
How do triggers work?
Can we insert data into view sql server?
What are different types of subquery?
What is a database in ms sql server?
Can an automatic recovery be initiated by a user?
How to declare and use cursor variables?
Can we use where clause in union?
What are the differences between char and nchar in ms sql server?
What are data files?
When would you use the stored procedures or functions?
Explain aggregate functions?
Write a program to fetch first 10 records from a file?
What are logical database components? : SQL Server Architecture
mention different types of relationships in the dbms?
