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 Unit Testing in SAP?
1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
what is the difference b/w 4.6c & 4.7EE?
How to see when were the optimizer stats last time run?
Where do you download trail version of sap ecc, what is sap cal?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
If you have a long-running Job, how do you analyse?
i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
I would like to know the version or name of SAP that is implemented in real time?
What is the difference between – support package, kernel and sap note?
How do you kill a job in SAP?
How many types of work processes are there in sap ?
What is MySAP?
