Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 10964 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
How you can make a parameterized view?
What is database design and development?
How to use timestamp datatypes
How would you design a database for an online site, which would average a million hits a day?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the storage and physical database design?
How to generate OIDS
Explain about relational database management systems?
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
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 18 schemas?
What is normalization? Explain different levels of normalization?
How can you log an error to the server event log from a stored procedure?
What is the maximum length of an extended property?
