Performance Tuning steps?

[Former Member]

Hi ,

What r the peformance tuning steps to increase the performance of ABAP Programs?In Select statement what must be included and what must not be included.?

What is "for all entries"?In this "for all entries" is there any pre-condition before using "for all entries"?

Regards,

gopi.

[Former Member]

In the select statement try to include all the key fields of the database table

For all entries.

For all entries is used , for each entry of the internal table specified an entry will be selected for that in the second select statement

Prerequisite : Internal table specified in for all entries should not be empty

eg:

select matnr from mara into table it_mara.

if not it_mara[] is initial. ---> <b>Prerequisite</b>
  select maktx from makt into table it_makt for all entries in it_mara where matnr = it_mara-matnr.
endif.

Here for every MATNR in it_maara , MAKTX will be selected

Message was edited by: Chandrasekhar Jagarlamudi

[RichHeilman]

Check out SE30, "Tips 'n' Tricks" button.

Regards,

Rich Heilman

[Former Member]

HI,

See the below link, you will find the Performance Tuning steps for Select statment and also other stuff for this Performance

http://www.sapgenie.com/abap/performance.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Thanks

Sudheer

[Former Member]

Gopi

Few guidelines.

1. Try and get only the required fields in the SELECT statement. eg SELECT fields INTO xyz FROM table

rather than using SELECT *.

2. Try and use the WHERE conditions in the SELECT query instead of checks and ifs within the loop.

For all enteries basically causes the the select statement to executed for all the entries in the particular internal table. Please note it is required that the internal table is populated otherwise it would fetch all data from select query (ignoring the where conditions)

Regards

Anurag

[Former Member]

Hi Gopi,

Following are the different tools provided by SAP for performance analysis of an ABAP object

Run time analysis transaction SE30

This transaction gives all the analysis of an ABAP program with respect to the database and the non-database processing.

SQL Trace transaction ST05

The trace list has many lines that are not related to the SELECT statement in the ABAP program. This is because the execution of any ABAP program requires additional administrative SQL calls. To restrict the list output, use the filter introducing the trace list.

check these links:

http://www.sapgenie.com/abap/performance.htm

http://www.sapdevelopment.co.uk/perform/performhome.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_Introduction.asp

regards,

keerthi.