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 significance of technical settings (specified while creating a table in the data dictionary) ?
What are advantages and disadvantages of logical data base
What are local objects?
What is a data element?
What is the difference between synchronous and asynchronous update? : abap bdc
Which transaction code can I use to analyze the performance of abap program?
What is meant by read lock? : sap abap data dictionary
In sap script how to print bar code in vertical manner
Do you know any other patterns if yes.. explain
What is delivery class? : abap data dictionary
What is the use of the raising exception? : abap modularization
Why do we use FOR ALL ENTRIES and what is the pre-requisite
What is the difference between collect and append statements?
What are the basic components of dialog program?
Explain the difference between domain and data element?