Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is the significance of technical settings (specified while creating a table in the data dictionary) ?

1049


What are advantages and disadvantages of logical data base

2254


What are local objects?

1120


What is a data element?

951


What is the difference between synchronous and asynchronous update? : abap bdc

1189


Which transaction code can I use to analyze the performance of abap program?

1036


What is meant by read lock? : sap abap data dictionary

1036


In sap script how to print bar code in vertical manner

3265


Do you know any other patterns if yes.. explain

1303


What is delivery class? : abap data dictionary

1244


What is the use of the raising exception? : abap modularization

989


Why do we use FOR ALL ENTRIES and what is the pre-requisite

1411


What is the difference between collect and append statements?

1082


What are the basic components of dialog program?

1249


Explain the difference between domain and data element?

1023