You are running a report. It is taking long time for
execution. What steps will you do to reduce the execution time.
Answer Posted / venkateswari
in this u should n'tuse select *
do n't use nested selects
do n't use nested loops
do not use select and end select
do n't use use select query in a loop
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the domains and data elements?
What are the different types of operators in the sap abap?
What is the different type of projects? : sap abap hr
What is the difference between Check and Continue?
How do you move on to the next screen in interactive reporting?
What are the pooled and cluster tables?
Explain the advantages of different types of bdc's?
What functions does a data dictionary perform? : abap data dictionary
Select query optimisation
What are internal tables? How do you get the number of lines in an internal table?
What is a persistent class?
Explain the difference between a pool table and a transparent table and how they are stored at the database level?
What are the Synchronous and asynchronous methods in bdc ?
What do you do when the system crashes in the middle of a BDC batch session?
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?