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
What data is contained in data dictionary? : abap data dictionary
What are the data types of internal tables?
Fallback class
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
Concepts of OO ABAP and why we are using it?
What is the difference between bdc_okcode and bdc_cursor? : abap bdc
What is the company code? : sap abap hr
What is the tcode to create indexes?
What is pretty printer?
What is a data dictionary? : sap abap data dictionary
What does the extract statement do in extract datasets? : abap modularization
What is tcode se16? For what is it used.
What are user exits? What is involved in writing them? What precations are needed?
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
What is open sql?