Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the difference between data elements and domains? : abap data dictionary
What is a size category? : abap data dictionary
How is conversion of data types done between abap/4 & db layer? : abap data dictionary
What are the Various Types of internal tables?
What are the main events of which are used for logical database?
How many types of data classes are there in sap?
what are the two methods of modifying sap standard tables ?
How to find Kernal badi ?
How do you find out whether a file exits on the presentation server?
In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?
Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?
How to create user interfaces for lists?
Why do we need enhancements?
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
What is view? Different types of view.
