Index reorganization and rebuilds
Indexes on data, custom, structural, and calculation result tables are crucial for ensuring quick data retrieval. Over time, as data is added, updated, or removed, the indexes associated with these tables become fragmented, which slows down data fetching operations. In order to restore performance, the indexes can be reorganized or rebuilt.
Scheduling index maintenance
Index reorganization and rebuilding of data, custom, structural, and calculation result tables can be done through the Scheduler module in Incentives.
Considerations
The duration for reorganizing or rebuilding indexes can vary from minutes to hours, depending on the table size.
It is recommended to schedule these operations over the weekend, outside of regular batch runs or periods of high Payee Web activity.
The standard practice is to perform index reorganization when fragmentation levels are between 5% and 30%.
If fragmentation exceeds 30%, it is advisable to rebuild the index.
As fragmentation percentages are not visible through the Admin Client, Technical Solutions can offer guidance on when to reorganize or rebuild indexes and provide assistance in scheduling these operations effectively.
Proactive maintenance strategies
Scheduler processes can be configured to proactively reorganize indexes on Incentives objects that undergo minimal data changes.
For objects with frequent data changes, a full index rebuild is recommended.