|
- Performance tuning methods
- Always check the driver internal tables is not empty, while using FOR ALL ENTRIES.
- Avoid for all entries in JOINS .
- Try to avoid joins and use FOR ALL ENTRIES.
- Try to restrict the joins to 1 level only ie only for 2 tables .
- Avoid using Select *.
- Avoid having multiple Selects from the same table in the same object.
- Try to minimize the number of variables to save memory.
- The sequence of fields in 'where clause' must be as per primary/secondary index ( if any).
- Avoid creation of index as far as possible.
- Avoid operators like <>, > , < & like % in where clause conditions.
- Avoid select/select single statements in loops.
- Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.
- Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,).
- Avoid using ORDER BY in selects.
- Avoid Nested Selects .
- Avoid Nested Loops of Internal Tables.
- Try to use FIELD SYMBOLS.
- Try to avoid into Corresponding Fields of .
- Avoid using Select Distinct, Use DELETE ADJACENT.
|
0 comments:
Post a Comment
Your useful comments, suggestions are appreciated.Your comments are moderated.