Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is performance tuning?

Answer Posted / manojkumar kotti

Following standards should be followed to improve the performance.

1. Avoid using * in select query.
2. Avoid using move corresponding.
3. Avoid using nested selects.
4. Avoid using nested loops.
5. Avoid using select query within loops.
6. Try to use the primary key with select query based on the requirement.
7. Fields in the select query should be in the same order as existing index
8. Avoid using delete statement within loops.
9. Use binary search clause with read statements.
10. Avoid using appending corresponding fields clause.

Regards,
Manoj.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?

1885


What is the meaning of abap/4 editor integrated with abap/4 data dictionary?

1099


Print options in smartforms?

2006


What is sapnet?

1456


Explain about drill down report?

9205


What are the different types of parameters? : abap modularization

1190


What is meant by authorization? Did you ever work on it? : sap abap hr

945


What is asap methodology? : sap abap hr

1111


What is the difference between RETURNING and CHANGING parameters for a method?

1765


What are the two different ways of building a match code object? : abap data dictionary

1136


How to combine multiple billing into one RV document ( Step by Step)?

1971


How to define selection screen?

1124


What is a variable in the sap abap?

1047


What are interface/conversion programs in SAP?

1169


How can we access the correction and transport system?

1063