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 are the different methods of passing data?
Why do we use Abstract classes give an example from your project?
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
What is the use of abap data dictionary? : abap data dictionary
How to maintain lists?
Difference between sap script and report?
How many main windows will be there in a page window?
What is the difference between a dialog program and a report?
What are the types of windows in sap script?
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
What are conversion routines? : abap data dictionary
What is page window?
Explain different types of attributes of function module?
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul
What are the different types of data dictionary objects? : abap data dictionary
