Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can we display a list in a pop-up screen other than full-size stacked list?
What are the basic functions of database utility? : abap data dictionary
Why is pretty printer user in abap?
How will you insert record in a sorted table
What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr
can anyone please tell me, in orient paper mill project which fields exits for creating report.
What are control tables?
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
How many types of views are there ?
Explain the difference between free and refresh?
How to upload data using catt ? : abap hr
What is a 'z' report?
What are field symbols?
What are the value tables?
Explain how to create any functions?
