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


Please Help Members By Posting Answers For Below Questions

What is time constraint ? : abap hr

704


Have you set up a back ground job ? How to create a background job without a variant ?

651


When to use logical database?

575


What is difference between dependent and independent data?

570


Explain the advantages of different types of bdc's?

555






What is a data dictionary? : sap abap data dictionary

557


Explain the concept of clusters in payroll

2135


How do you read files from the application server ? : abap bdc

617


What are the functional areas?

622


What are the attributes of the data in data dictionary? : abap data dictionary

609


Name a few data dictionary objects? : abap data dictionary

691


Define alv programming in abap?

708


What is off cycle payroll run

1957


what is leave to TRANSACTION?

1007


What is a view in sap? : abap data dictionary

634