What are the disadvantages of cursors? How can you avoid
cursors?
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
How long can an error message be in raiseerror function?
What is the physical representation for a many-to-many relationship?
What are the three basic rules which are to be followed for the relational model of the database?
What is normalization? Explain different levels of normalization?
Explain about the relational database?
Explain about relational operator join?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Why does this query return 0?
Who are naive users?
How would you design a database for an online site, which would average a million hits a day?
How is data stored in dbms?
Explain about the storage and physical database design?
What is an application role and explain a scenario when you would use one?