Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashwin mane
Cursors do provide a number of benefits. These benefits
follow from the fact that if you do not use a cursor, the
entire result set must be transferred to the client for
processing and display:
1.Client-side memory - For large results, holding the
entire result set on the client can lead to demanding
memory requirements.
2.Response time -Cursors can provide the first few rows
before the whole result set is assembled. If you do not use
cursors, the entire result set must be delivered before any
rows are displayed by your application.
3.Concurrency control -If you make updates to your data
and do not use cursors in your application, you must send
separate SQL statements to the database server to apply the
changes. This raises the possibility of concurrency
problems if the result set has changed since it was queried
by the client. In turn, this raises the possibility of lost
updates.
Cursors act as pointers to the underlying data, and so
impose proper concurrency constraints on any changes you
make.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the procedure to applying patches?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
before doing client copy you have to adjust table space at os level.what is the single command for that?(with out going through all the menu of brtools)
What are patches you applied?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
Explain checkpoint?
What is you allocate disks to different areas in sap?
Explain segment?
Do you know about oss what do you do with oss?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
What will you do if u got Update failure?
Explain what is luw (logical unit of work)?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
What is XI3.0? Explain XI
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
