Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 10906 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul kumar
A) In cursors each time you fetch a new row it does a round
trip with the database thereby increase network use and time.
B) There is also restriction on select statements that can be
used in cursors
C) It also uses more resources and temporary memory
Cursors can be avoided with the help of careful
implementation of while loop and other set based operations
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are the three basic rules which are to be followed for the relational model of the database?
What is the physical representation for a many-to-many relationship?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the hierarchical model of the database?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to customize error conditions.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What are the key features of dbms?
fact table and dimension table containg one to many relationship or many to one relastionship
In which database can extended stored procedures be added?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is the maximum length of an extended property?
Who are end users in dbms?
Explain about xml databases?
What is the database development process?
