1. Parallel Cursor method : technique used when you have to use loop inside a loop.
2. Parallel processing method : For optimized usage of work processes available.
Here we write the main processing logic in a function module and we will pass packets of data to this FM and process the data in parallel threads.
3. Using BINARY SEARCH with READ TABLE statement for a sorted table.
Using Hash table with READ TABLE statement.
4. Complete specification of all the Primary key fields in the WHERE clause of a SELECT query.
5. Activate buffering for small master data tables which are accessed frequently and updated rarely.
6. Use ST05 tool for measuring the sql statements performance and SAT(SE30) for measuring the application performance .
2. Parallel processing method : For optimized usage of work processes available.
Here we write the main processing logic in a function module and we will pass packets of data to this FM and process the data in parallel threads.
3. Using BINARY SEARCH with READ TABLE statement for a sorted table.
Using Hash table with READ TABLE statement.
4. Complete specification of all the Primary key fields in the WHERE clause of a SELECT query.
5. Activate buffering for small master data tables which are accessed frequently and updated rarely.
6. Use ST05 tool for measuring the sql statements performance and SAT(SE30) for measuring the application performance .