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 a predefined type in abap?

1122


Badi concepts

1334


How do you populate data into a multiple line field? : abap bdc

1075


What are the different types of parameters? How can you distinguish between different kinds of parameters?

946


What are the basic objects of the data dictionary? : abap data dictionary

1033


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

8463


What are subroutines? : abap modularization

1040


Value table VS check Table.

1418


What are extracts?

962


What are th control break events in abap?

1036


What is full form of bdc session? : abap bdc

1128


What is Field group?

1059


In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?

1035


What is an update type with reference to a match code id? : abap data dictionary

950


What are the difference between call screen and leave screen?

1123