Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 11073 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 to read and create .LDC data files which are used by linguatic dictionary.
Why does this query return 0?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
explain detail about ftp in datastage?
Write the fastest query to find out how many rows exist in a table?
What is dbms and its application?
How long can an error message be in raiseerror function?
What is data modeling with example?
Explain the cube operator?
Explain about query and reporting.
What are the 18 schemas?
Explain the rollup operator?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How can you fix a poorly performing query?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
