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
What is the difference between collect and append statements?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
Does the external program run in the same sap luw as the caller, or in a separate one?
What are the 3 types of tables in sap? : abap data dictionary
How we can give authorization on the fields of table control in a dialog-programming?
What are the types of the programming language used in the sap abap software?
In delivery processing which step comes first picking, packing, posting goods issue ?
What are the system fields you have worked with? Explain?
What is the step-by-step process to create a table in data dictionary? : abap data dictionary
Explain the inside concept in select-options?
What is an Open Item in SAP? How will you find an Open Item in SAP?
Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
What are the dynamic actions and how to configure it? : sap abap hr
How you attach search help to data element? : sap abap data dictionary
