doubt in SQL Trace

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Vishnu Priya,

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

Ranjith

[Former Member]

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