What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
in the final display list how can i change rows to columns and vice versa
How to find Buffered or not?
2 Answers Cap Gemini, Unilogic Software, Visa Steel,
how to use table control in bdc
What are the different types of view?
what is the standard program used to upload/download layout sets in scripts.
Explain a report that you recently did?
4 Answers Atos Origin, Cap Gemini, Deloitte, FutureSoft,
Explain the use of insert and append statement in sap abap?
How many sessions will be opened using bdc_open_group?
what is ment by buffering?
Explain what is a foreign key relationship? Explain this with the help of an example.
How do you display a data in a detail list?
What is Basic IDOC type?