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 difference between central instance & application server?
Which transport directory is used to implement support package and add-ons?
What is client administration in sap system? Why do we use multiple clients in sap system?
How do you solve oracle archive struck?
What is the purpose of table tdevc?
What is transport domain?
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
Which are the most frequent errors encountered while dealing with transports ?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
What is “data sets” in sap?
Explain domain controller?
What are the activities you done in EP?
What are the categories to execute sap background jobs?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
Explain what is the importance of table t000?
