Analysing details of SQL trace and runtime analysis for a report.

[Former Member]

Hi,

I am trying to tune the performance of a Z ABAP report for target group export. A brief overview of what is done in the report is the retrieval of BP details present in the Target group including BP general, address, marketing attributes, person responsible and contact person details. As the target groups can be quite huge (around 6000 BPs), the report gives performance issues. I want to understand on how to analyse the details which I obtained from the run time analysis and SQL trace and on how to take it forward.

Any inputs in this regard would be helpful.

Thanks in advance,

Anushree

[former_member585060]

In Runtime analysis Look for

ABAP - In your ABAP code

DATABASE - It shows the performance of your SELECT statements in your program.

Just check how much % it is showing for both.

Check for following in your code.

1) Avoid SELECT *

2) Clear internal tables values which are not required at the ending of program, as it saves memory

etc.