topic Re: Using ST05 in Application Development and Automation Discussions

Using ST05

Former Member — Fri, 07 Aug 2009 10:10:03 GMT

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??

Re: Using ST05

Former Member — Fri, 07 Aug 2009 10:34:40 GMT

This message was moderated.

Re: Using ST05

Former Member — Fri, 07 Aug 2009 12:07:43 GMT

Hi,

Check this simple blog on the ST05 transaction.

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

Re: Using ST05

Former Member — Mon, 10 Aug 2009 04:11:48 GMT

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.

Re: Using ST05

Former Member — Mon, 10 Aug 2009 07:01:51 GMT

> 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