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
Do you know any other patterns if yes.. explain
What is logical database? : abap hr
out bound process code for quotation?
What are local objects? : abap data dictionary
How do we handle multiple line items in BDC's.
Define the various contents of technical specifications ?
How do you find if a logical database exists for your program requrements?
How to call a subroutine in sapscript?
Explain what is a logical database?
What is the differences between abap and ooabap. In which situation we useooabap?
What is the project you are currently working and work that you are doing
How do you use tab sets in layout sets?
What are the functional areas? User groups? and how does ABAP query work in relation to these?
What are the system fields? Explain?
Can we display a list in a pop-up screen other than full-size stacked list?