‎2007 Apr 25 11:16 AM
what is the difference between run time analysis and sql trace plz explain clearly and exactly?
‎2007 Apr 25 11:27 AM
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
‎2007 Apr 25 11:18 AM
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
‎2007 Apr 25 11:18 AM
<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
‎2007 Apr 25 11:27 AM
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
‎2007 Apr 25 11:30 AM