Answer Posted / amith
Performance tuning is a technique used to fine tune your
ABAP programs when they have complex select statements and
huge set of data to be accessed from database.
Performacne of a scelect statement or a program can be
tested using tools like SE 30- Runtime analysis and SQL
Trace ST05.
Other than this there are set of thumb rules that can be
followed:
1) Keep the data selection small.
 Avoid unnecessary data across the network
 Always use the where clause
 Avoid selecting useless data we filter later.
 Use the index of the relevant database tables to
make the where clause more efficient
 Avoid using complex where clauses
 If possible avoid using the NOT in conjunction with
the where clause.
2) Transport as little data as possible
• transport only fields that are really used
• use the aggregate functions in the select clause
for calculations
• Consider using the distinct statement if there is
possibility of duplicate entries
3) Use fewer data base access
• Transfer all of the data at once frm data base to
internal tables.
• When possible avoid accessing the same data again
and again
• Avoid using nested loops instead of that use an
internal table and use the select for all entires statement.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the main events of which are used for logical database?
Can we define our own match code id's for sap matchcodes ?
What are the different types of parameters?
What is the difference between semi-monthly and Bi-weekly payroll area
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.
What is collective search help? : sap abap data dictionary
Explain the advantages of different types of bdc's?
What are the two ways of producing a list within a transaction?
What are the types of table fields in the sap abap?
How is conversion of data types done between abap/4 & db layer? : abap data dictionary
Explain what are the system fields? Explain?
What is example class
What are null values?
What is sap script? Describe its components.
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
