The implementation process generates many indexes based on specifications during the install. PeopleSoft employees know it is necessary to change indexes at customer sites. Thus, as a customer, you will need to evaluate how PeopleSoft is implemented and plan your index changes accordingly. The PeopleSoft indexing strategy It is worthwhile to understand how PeopleSoft does its index design. Table 1 lists the indexes that are provided with the PeopleSoft product.
Companies often discuss the generated indexes and reach some generalizations about tuning.
The generalizations often help other companies in some areas, but hurt in others. Index tuning guidelines Figure 1 offers a set of guidelines for tuning PeopleSoft or other existing applications. It also leads to a large number of indexes being defined on tables. DB2 referential integrity is not used, and it is important to leave these unique indexes unchanged. The primary index is often the only index defined as unique on a table.