topic Re: general in Application Development and Automation Discussions

general

Former Member — Wed, 25 Apr 2007 10:16:33 GMT

what is the difference between run time analysis and sql trace plz explain clearly and exactly?

Re: general

Former Member — Wed, 25 Apr 2007 10:18:32 GMT

RTA is used for unused data, obsolute things, problamatic statements etc.

whereas SQL trace is used for finding how much time it's taking for each and every database hit

reward if useful

Krishna K

Re: general

Former Member — Wed, 25 Apr 2007 10:18:46 GMT

<b>dont u search before posting IT ?

please give meaningful name to the thread.

please search in this form, pplease dont post duplicates.</b>

Regards

Prabhu

Re: general

Former Member — Wed, 25 Apr 2007 10:27:55 GMT

Hi,

In runtime analysis SE30 you can find the execution time for your programs Tcodes etc and compare your ABAP Vs Databse Vs System times..

Run a program here in SE30 and click the Analyze button in the bottom..

Where as in SQL trace ST05 you can see the time taken for each SQL statement you have written in the code and change the statement so that it takes minimum execution time depending on the index trace.

reward if useful.

regards,

nazeer

Re: general

Former Member — Wed, 25 Apr 2007 10:30:31 GMT

thank for replying me .