ST05 Explain plan

[Former Member]

Can anyone please explain how to analyze "explain plan" results in transaction ST05?

[Former Member]

Hi Deepti ,

The following details will help you regarding trace by st05

When to use ST05 SQL trace ?

1) When database time is > 40 % of the total response time.

2) + When a program or transaction has poor response time+

3) ABAP code analysis in general

When you see the exetended trace list .Look for "Duration " in RED and Hit the explain button on the top

Perform explain plan for the SQL’s in question.

List the data sorted by table access.

List statement summary and identical selects.

View the Data Dictionary Information to display the Object DD details.

Click on ABAP display to view the ABAP Program

Select Trace -> Display Variables to show the Selected SQL statement

with the variable values instead of the variable names

All SQL’s with duration higher than 150,000 microseconds.( highlighted in RED ) needs to be analyzed and fixed.

Eliminate the following –

Full table scan.

Missing indexes.

In-effective SQL’s with non-selective field criterion.

Higher cost.

Complex joins.

Select * statements

Joins on pre-defined views.

Hope this info might help you

Regards,

Gokul B

[Former Member]

Quite a bit of the information in ST05 is DB specific. A good place to start is to search for 'ST05 FAQ' within the SAP Notes area and select your DB from the list that appears.

Hope that helps.

J. Haynes

Edited by: Joe Haynes on Mar 10, 2008 10:52 AM

[Former Member]

Hello,

In t-code: ST05-----performance Analysis.

1) select SQL trace and

select Trace Function----Activate Trace

THIS ACTIVATES THE USER.

2) Select Trace Function---Activate Trace with Filter

HERE WE CAN TRACE T-CODE AS WELL AS PROGRAM.

3) Deactivate Trace----by clicking this we can deactivate the Activated Trace.

4) Display Trace-------we can view the trace list.

[Former Member]

I know how to activate/de-activate trace.

My question is how to analyze the results?What are the benchmark values ?