You are running a report. It is taking long time for
execution. What steps will you do to reduce the
execution time.
Answer Posted / pradipta mahato
Hi,
Ideally we should follow following thing for good performane
1. Avoid select inside loop (select out of loop and read it
inside)
2. Avoid nested loop and unnecessary extra loop in code
3. Change loop to read if there is a chance
4. Avoid join better use 'for all entries'
5. read internal table using binary search ( Sort it first)
6. If select statement creating problem then index could be
created
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
Can a domain, assigned to a data element be changed?
Explain the difference between function group and function module?
What are number ranges?
what is call back in alv?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
Can we create an abap program without using y or z?
What is view? Different types of view.
In sap script how to print bar code in vertical manner
Why grouping of fields is required? What is the max no of modification groups for each field?
What is the difference between call transaction method and the session method? : abap bdc
What is the use of start-of-selection.,if not use in report what will happen,?
What are the merits of its?-
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
What is a persistent class?