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 function of the transport system and workbench organiser?

1150


What is luw?

1301


What are the advantages and disadvantages of ABAP query tool?

1041


What are the user interfaces of interactive lists?

1111


Did you create primary index?

1184


What does the insert statement in extract datasets do? : abap modularization

1106


What are the functional areas, user groups? How does abap query work in relation to these?

1100


Can there be more than 1 main window in sap script?

1139


What is an update task? : abap modularization

1126


What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary

1156


Explain buffering concept usage?

1056


What is the collect statement?

1187


What are the different types joins?

1193


How can we determine a vendor is Bloc/Unblock from the table LFA1?

2136


Sal abap on hana interview

1427