what we have to do in st05 and se30?

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


Please Help Members By Posting Answers For Below Questions

What is the significance of delivery class?

584


Explain about Recording Function?

670


What is the structure of the bdc table? : abap bdc

732


Difference between open sql and native sql? : abap data dictionary

612


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

750






What is the difference between function group and function module?

521


how to see the tables of 200 in client 100?

1411


What are the advantages and disadvantages of ABAP query tool?

579


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

3263


What kind of financial periods exist in sap? What is the relavent table for that?

627


What are the differences between domain and data element?

576


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.

1899


How can we create callable modules of program code within one abap/4 program?

622


What is the max no of match code id's that can be defined for one match code object? : abap data dictionary

649


What is the difference between a pool table and a transparent table?

544