Using ST05

[Former Member]

Hi Everybody,

I have used a SELECT statement to fetch some fields of a SAP standard table. I activated SQL trace in ST05 before executing the select statement and then after execution I deactivated and then when I click on Analyze button, I'm seeing so many select statments and also unable to analyse the performance of my SELECT statement.. Can any body tell me how to go to my SELECT statement and do the analysis.....I mean how can we judge whether it is efficient or not??

[Former Member]

This message was moderated.

[Former Member]

Hi,

Check this simple blog on the ST05 transaction.

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

[Former Member]

HI

When you are using ST05 if the select statement is not up to the performance level means then that will come in red color (or some different color). So there search using the table name in the ST05 output.

I will suggest you to post that respective select statement so that somebody can you help you regarding this and regarding ST05 you want know means read some material regarding that.

Thx.

[Former Member]

> means then that will come in red color (or some different color).

no, forget the colors in both traces

Read my blog mentioned above and use the summary, start with the statements which are most expensive. The summary shows you all executions sumed up and that is what you want to see.

Siegfried