Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

general

Former Member
0 Likes
464

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
441

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

4 REPLIES 4
Read only

Former Member
0 Likes
441

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

Read only

Former Member
0 Likes
441

<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

Read only

Former Member
0 Likes
442

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

Read only

0 Likes
441

thank for replying me .