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 is check table?
wat are the process that can be executed & tracked in a workflow?
What was the requirement of IDoc in your project? How it was working?
Which objects are independent transport objects?
Can we write the code both call transaction and session method in single program?
What are the function modules used in a sap script driver program?
Difference between sap script and report?
How do you find if a logical database exists for your program requrements?
Explain about Recording Function?
What does the insert statement in extract datasets do?
What are the advantages of logical databases?
Module Pool Programming: Events and Table Control handling.
What is the difference between tables and structures?
How do you do bdc for a table control? : abap bdc
What is the differrences between structure and table in data dictionary in abap? : abap hr