You are running a report. It is taking long time for

[Former Member]

You are running a report. It is taking long time for

execution. What steps will you do to reduce the

execution time.

plx explain clearly

[Former Member]

Hi,

goto se38,

menu-environment-examples-performance..

there are some tips given to enhance the performance.

try those.

regards,

pankaj singh

• reward if helpful

[Former Member]

Avoid loops inside loops.

Avoid select inside loops.

Select only the data that is required instead of using select *

Select the field in the sequence as they are present in the database, and also specify the fields in the where clause in the same sequence.

When ur using for all entries in the select statement, check whether the internal table to which ur refering is not initial.

Remove select... endselect instead use into table

Avoid Select Single inside the loop, instead select all the data before the loop and read that internal table inside the loop using binary search.

Sort the Internal tables where ever necessary.

[Former Member]

Remove SELECT...ENDSELECT

Use INTO TABLE addition of SELECT

Avoid INTO CORRESPONDING FIELDS

When ever using Read table use Binary Search

Use table buffering for frequently used tables

Use OPTIMIZED SELECT stmts; specify all filter conditions in the Where-clause

Regards

Wenceslaus