what we have to do in st05 and se30?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / akram
sto5 is sql trace
se30 is runtime analysis used to exmine the performance of
an abap-program,transaction and functio;n module.
when we activate sql trace we can find out how many tables
are updated when we perform a transaction.
Is This Answer Correct ? | 3 Yes | 2 No |
how many pages in sap scripts 00to98 or 00to99 ...?
what is ment by view?how many types are there ?what are they?and what is the difference between data base view and projection view?
what is the purpose of RDBMOIND RPOGRAM?
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
What are V1 & V2 updates within the SAP LUW? Why & How they occur?
what is the difference between at first & at new statements ?
What are the organizational related infotypes? : abap hr
What is static attribute
What is the advantage of structures? How do you use them in the ABAP programs?
what is the standard program to check the consistency of partner profiles?
Utility of bdc cursor?
What is a function group? : abap modularization