topic Re: doubt in SQL Trace in Application Development and Automation Discussions

doubt in SQL Trace

Former Member — Fri, 10 Nov 2006 10:49:38 GMT

Hi all,

As per my konwledge we will be going to st05 for fine tunning SQL Statements, but when we go there iam finding some sql statements which are in embeded SQL fromat how to see them in open sql format and change that SQL statment as part of Fine Tunning.

Thanks in advance.

Ranjith

Re: doubt in SQL Trace

Former Member — Fri, 10 Nov 2006 10:55:24 GMT

For performance tuning, SE30 tcode can be used. INn se30, you can actually see the gross amount consumed by the query and can concentrate on the select statements for performance improvement.

In ST05, we can see the SQL statement execution plan, and the indexes on which the SQL statement it is running. This would not answer your question, but just for information

Regards,

Vishnu Priya

Re: doubt in SQL Trace

Former Member — Fri, 10 Nov 2006 11:02:13 GMT

Hi Vishnu Priya,

Thanks for giving me additional information. if possible please give me the detailed information on the above mentioned question.

Ranjith

Re: doubt in SQL Trace

Former Member — Fri, 10 Nov 2006 11:20:03 GMT

Try this way. Place the cursor on the select statement and click on the 'Explain' button on the toolbar. Check if you can see the select statement.

Regards,

Vishnu Priya