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 logo in sap script?
What is a batch input session? : abap hr
Explain the advantages and disadvantages of abap query tool?
How can we omit a leading sign and a leading zero in sapscript?
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
What is a report?
What is the relationship existing between the various data elements? : abap data dictionary
What is the tcode to create indexes?
How we format the data before writing a statement in the report?
What is logical database? : abap hr
What is a view? : abap data dictionary
What are the different message types available in the abap/4 ?
How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?
What is repository info. Systems? : abap data dictionary
Explain difference between primary key and unique key?