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 are the functional areas? User groups?
What is singleton pattern in OOPS?
Folder types in smatforms? 2)What is Command line?
Explain the difference between get and get late?
Explain what is a logical database?
How many types of tables exists and what are they in data dictionary?
What are roles and authorization objects?
How to eliminate duplicate entries in internal tables?
What is modularization and its benefits?
How to convert the Unit for 'Distance' (The value from one Unit to another).
What are the events in screen programming?
What are the different types of data dictionary objects? : abap data dictionary
What is the difference between ABAP and HR ABAP
What does the ‘suppress dialog’ do?
SM35 transaction, How to automate BDC ?