What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?
Answer Posted / sumeet patil
Performing an SQL Trace:
Access transaction ST05. From the initial screen, click the check box for SQL trace, under the trace requests, click Trace on.
Run the program containing the SQL query that needs to be analyzed in the SE38 editor.
Come back to ST05 screen, under Trace requests, click Trace off.
Click List trace to view the trace of the current statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the function of the transport system and workbench organiser?
What is luw?
What are the advantages and disadvantages of ABAP query tool?
What are the user interfaces of interactive lists?
Did you create primary index?
What does the insert statement in extract datasets do? : abap modularization
What are the functional areas, user groups? How does abap query work in relation to these?
Can there be more than 1 main window in sap script?
What is an update task? : abap modularization
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
Explain buffering concept usage?
What is the collect statement?
What are the different types joins?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
Sal abap on hana interview