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


Please Help Members By Posting Answers For Below Questions

Which FM do you use to find out who is reporting to whom

5423


What are screen painter and menu painter? : abap hr

757


What is locking? : abap data dictionary

863


A subroutine can contain nested form and endform blocks. State true or false. : abap modularization

1014


What is a data element?

713


What is sap locking?

778


What are the drill-down features provided by abap/4 in interactive lists?

795


How do you process errors in session method ? : abap bdc

781


PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'

3924


Why do we need enhancements?

835


What data is contained in data dictionary? : abap data dictionary

877


What are the different window types in sapscript?

752


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2305


In the `select' statement what is group by ?

1704


What are the user groups?

782