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
What are clustered tables?
What is “call mode”?
wat are the process that can be executed & tracked in a workflow?
What is meant by hide area?
Which transaction code can I used to analyze the performance of ABAP program.?
Where do you find info on new developments in SAP?
What is the advantage of structures?
What is the difference between Exit and Stop?
What is the purpose of sum statement?
Define the various contents of technical specifications ?
What is screen flow logic? What are the sections in it?
What are the organizational related infotypes? : abap hr
What are the update types possible?
What is the use of a pretty printer?
What are ranges?