What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?

Answer Posted / renuka

SQT Trace is used to analize the performance of select
queries.Transaction code is ST05.

STEPS:
go to ST05
selet Active mode
select Trace on
select application provide the transaction code in command
line like xk01,xd01 like that
now enter the data in application
again go for ST05
select Inacivemode
Trace off
List Trace

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Work most on which module: name a few tables?

598


What are the uses of table pool or table cluster.

535


Explain the different types of mode (run code) in call transaction method?

565


What is tcode se16. For what is it used. Explain briefly?

542


What are the basic objects of the data dictionary?

572






What are the domains and data elements?

930


What is sap abap data classes?

607


In order to upload purchase order details, how you handle multiple values for a single field?

565


What are the personnel administration related infotypes? : abap hr

608


What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc

615


A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization

561


Explain how many types of tables exist and what are they in data dictionary?

605


There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.

935


What is page window?

578


State the differences between database view & projection view? : abap data dictionary

610