Advantages and Disadvantages of Cursor?
- 15 Answers
- 97872 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / bed singh
1. We can do row vise validation but performance is
slow.
2. Each time we fetch a row from the cursor, it result
a network round trip, where as a normal select statement
query make only one round trip.
3. If the ResultSet is less than 50 or 100 records it
is better to go for implicit cursors. If the result set is
large then you should use explicit cursors. Otherwise it
will put Burdon on CPU.
| Is This Answer Correct ? | 43 Yes | 12 No |
Post New Answer View All Answers
How do I find the size of a sql server database?
Can the query output be sorted by multiple columns in ms sql server?
Why are sql functions used?
Should you normalize audio?
what information is maintained within the msdb database? : Sql server administration
What is database architecture? : SQL Server Architecture
When would you use a before or after trigger?
What is acid db?
When does a workload on SQL Azure get throttled?
What is autocommit mode in sql server?
How to test odbc dsn connection settings?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is the bookmark lookup and rid lookup?
What is plan freezing?
List some advantages and disadvantages of stored procedure?
