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 |
What are work process in ABAP?
i want to see a material master data which is at client side.How can i view that?
What is the significance of main window in a page, what are the types of the window?
when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal table. What will be the result? (2nd internal table contains records).
What is bdc programming? : abap bdc
What is the abap program name to process the batch input session automatically? : abap bdc
How can we call, call transaction and session method in the same program?
while creating table in ECC 6.0,it'll ask for enhancement Catagory?What is that?
Suppose i have table with 2 columns say 1st with Numerics and 2nd with words like 1 for one and 2 for two......so.if i want to change the 9 numeric word as some twenty...how?
Did you create primary index?
WHAT IS COMPOSITE KEY??
What abap statement will trigger list generation?