Skip to Content

Performance Improvement using Indexes and ABAP Hints

Optimized performance of background jobs are a prerequisite in live production environments. No matter how optimized the ABAP code is, over a period of time due to accumulation of large amounts of data in tables, programs can go into a long run. In such instances, index definitions needs to be checked. If the query is such that it cannot use the primary key, creation of a secondary index can be considered. There are instances when the SAP Cost Based Optimizer (CBO) over-rides the secondary index and continues to do a sequential read on the table. At such times, coding an ABAP hint that would force the CBO to use the secondary index can be used.

View this Document

Former Member

No comments