An entire description of the topic constitutes a book by itself. However, we will see some useful and important techniques, as well as some new tools and concepts that are important for developers for program optimization. There are two main techniques—optimizing database statements, particularly
SELECT statements and the optimizing ABAP code particularly internal table's access. We will see useful recipes related to both the optimization of database statements as well as internal tables.
We will start with some general rules necessary for optimization. We will start with a recipe showing the usage of transaction SAT for measuring performance of report programs. Then, we will see in detail the steps required in creating secondary indexes for database tables in order to boost performance of queries used in the concerned program. We will then see how hints may be used in programs within SELECT statements, so that a particular index may be used by the system. Finally, we will see...