What Methods are using in Perform tuning
Answers were Sorted based on User's Feedback
Answer / pnrao.abap
Select Statement
Inner join
Subroutines
Debugging Techniques-Watch Point
- Breack Point
Runtime Analasys-SE30
SQL Trace-ST05
Data browser-se16
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / venkata ramamohana rao s
in select statement mainntain the list of field of what do
u want to fetch the information from DB instead of "select
* " and mention the primary key in where condition ins.
remove select and endselect statement.
using FOR ALL ENTRIES.
remove the nested loops.
never maintain the select statement between the loop.
remove the move-corresponding statement.
using select single
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / raghunath
check the select statements and use all the key fields in
the select statement.
Try using for all entrie where ever possible
Avoid select end select statement
Avoid select statement in a loop
use run time analysis nd try to redude the data base time
as low as possible.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / supriya
1. Should be the sequence of fields in Internal Tables n in
SELECT statement same as Database table fields sequence, 3
of the sequence should b same.
2. Try to use SELECT SINGLE statement
3. Always use BINARY SEARCH
4. Make use of Primary keys
5. Use ST05, SE30, SQLTrace
6. Avoid SELECT statement in Between LOOP ENDLOOP.
Is This Answer Correct ? | 1 Yes | 0 No |
Can we use same DATA ELEMENT for more than one field?
7 Answers HCL, Unilogic Software,
What are pool tables?
How to change standard data base table ?
what are the important fields while preparing sales order,inquiry?
What does the insert statement in extract datasets do? : abap modularization
What are pooled tables? : abap data dictionary
How to transfer legacy data into base tables by scheduling a time frame using bdc?
What are the three components of a work process?
How to eliminate duplicate entries in internal tables?
Without writing the event start-of-selection we can execute a report program.Then what's the purpose of writing it?
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
Differentiate between transparent tables, cluster tables and pooled tables