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
How to maintain lists?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What is append search help? : sap abap data dictionary
What is generic buffering?
Did you create help views?
Difference between user exit and badis?
What are the techniques involved in using sap supplied programs?
How do you populate data into a multiple line field?
There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.
What are the three components of a work process?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
Can I execute user exits? If yes, how?
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
difference between Valuation type and valuation category?
HOW CAN YOU USE A PAGE COUNT IN CALLING A PAGE IN SMARTFORM?
