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 was the requirement of IDoc in your project? How it was working?
Do you know any other patterns if yes.. explain
What are logical data bases used in hr module? : abap hr
What are the different window types in sapscript?
Is a logical database a requirement/must to write an abap/4 query?
What is an on”*-input filed” statement?
Explain how many types of tables exist and what are they in data dictionary?
State the system field for the current date?
What are the problems in processing batch input sessions?
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
Explain the use of insert and append statement in sap abap?
What are the different types of internal table?
What is the significance of the screen number ‘0’?
What is the procedure you followed to upload the data?
What kind of BDC programs are written ?