Patent attributes
Integral index management for a relational database is provided. Possible index management actions are identified to an administrator, and index management metric thresholds are provided by the administrator. An index metrics collection module automatically collects metric values. An index metrics analysis module automatically determines whether collected metric values satisfy specified thresholds. An index management action implementation module then implements index management actions, such as reorganizing or rebuilding indexes, adding indexes, and removing indexes. Threads may work in parallel on multiple tables of the relational database. Proposed actions may be subject to final authorization or may be implemented automatically after the metric threshold values are satisfied.
