Answer Posted / sravan
These transactions are widely used in performance tuning of
any program.
We use ST05 tcode to SQL trace. we use SQL trace to analyse
the time consumed by various select statements in program.
If any select statement is taking long time to retrieve data
from Database, we can re-look into that and make necessary
changes.
We use SE30 for runtime analysis. This is for overall
evaluation of program. By using this, we can know about time
consumed by various processes (dialog,select) .Best practice
is make the time consumed by SQL statements very less.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the significance of delivery class?
Explain about Recording Function?
What is the structure of the bdc table? : abap bdc
Difference between open sql and native sql? : abap data dictionary
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
What is the difference between function group and function module?
how to see the tables of 200 in client 100?
What are the advantages and disadvantages of ABAP query tool?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
What kind of financial periods exist in sap? What is the relavent table for that?
What are the differences between domain and data element?
data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.
How can we create callable modules of program code within one abap/4 program?
What is the max no of match code id's that can be defined for one match code object? : abap data dictionary
What is the difference between a pool table and a transparent table?