What Methods are using in Perform tuning

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of the transport system and workbench organiser?

843


How are BAPI different from Normal function modules ?

1786


What are the types of subroutines? : abap data dictionary

758


What is the difference between open_form and close_form?

811


What are two methods of modifying sap standard tables? : abap data dictionary

920






What is the definition of modification in an sap system and how do they impact an upgrade?

745


Can we call reports and transactions from interactive reporting lists?

831


In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.

2341


How do you retrieve the data for repetitive structures ? : abap hr

834


How do you get the number of lines in an internal table?

808


Difference between sy-tabix and sy-index?

1015


Explain sap abap 3-tier architecture?

966


What is a fall back class?

1219


hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.

1904


How can we set the tablespaces and extent sizes ?

735