Performance Tunning

[Former Member]

Can anybody help in writting the steps to be followed in SQL Trace as per performance tunning is concerned ?

How to effictively use the SE30 transaction & what are the things we should look for after performing this transaction for a particular program ?

[Former Member]

Hi,

1) Dont use nested seelct statement

2) If possible use for all entries in addition

3) In the where addition make sure you give all the primary key

4) Use Index for the selection criteria.

5) You can also use inner joins

6) You can try to put the data from the first select statement into an Itab and then in order to select the data from the second table use for all entries in.

7) Use the runtime analysis SE30 and SQL Trace (ST05) to identify the performance and also to identify where the load is heavy, so that you can change the code accordingly

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1...

1. Use Inner Joins

2. INTO TABLE

3. No nested loop

4. FOR ALL ENTRIES

5. Use as much of the key as possible

5. try to use primary or secondary keys in where condition. When using key fields, start with first key field.

6. Select only the fields you need for display/processing - avoid select *

reward if useful

Regards,

Anji

[Former Member]

You can get some tips & Tricks from SE30

goto SE30 , at the top u can see one button tips & tricks, click on that

[Former Member]

Hi.....

Just see the following links regarding Runtime analysis :

http://help.sap.com/saphelp_erp2005vp/helpdata/en/00/e0a73e5b7a424de10000000a114084/frameset.htm

http://help.sap.com/saphelp_erp2005vp/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm

Reward points if useful......

Suresh......

[Former Member]

Hello,

Check out this link:

<b>http://www.sapbrain.com/ARTICLES/TECHNICAL/optimization/optimization.html

https://wiki.sdn.sap.com/wiki/display/HOME/ABAPPerformanceand+Tuning</b>

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

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

Regards,

Beejal

**Reward if this helps