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
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?
What is the meaning of abap/4 editor integrated with abap/4 data dictionary?
Print options in smartforms?
What is sapnet?
Explain about drill down report?
What are the different types of parameters? : abap modularization
What is meant by authorization? Did you ever work on it? : sap abap hr
What is asap methodology? : sap abap hr
What is the difference between RETURNING and CHANGING parameters for a method?
What are the two different ways of building a match code object? : abap data dictionary
How to combine multiple billing into one RV document ( Step by Step)?
How to define selection screen?
What is a variable in the sap abap?
What are interface/conversion programs in SAP?
How can we access the correction and transport system?