Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100916 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
Do you know exporting and importing utility?
What is usually the first word in a sql query?
Explain the usage of floor function in sql server.
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Define inner join in sql server joins?
What is an identity?
What are orphan records?
What is a transact-sql statement?
Explain primary key in sql server?
How to create “dependant” parameter “make, model, year”
What is application role in sql server database security? : sql server security
What is data file in computer?
What is data block and how to define data block size?
Where cross join is used?
Determine when to use stored procedure to complete sql server tasks?
