Patent ID: 8489565

Claim:
A method for dynamically managing database indexes, the method comprising the steps of: identifying a relational database index management action to a user; obtaining from a computing system memory at least one threshold for each of at least four relational database index management metrics, the threshold and the metric associated with the identified index management action, the metrics being among the following possible metrics, not all of which need be present: amount of time a lock was held on objects without a specified missing index, amount of CPU used without a specified missing index, amount of memory used without a specified missing index, number of reads per disk sector without a specified missing index, size of disk queue length without a specified missing index, number of query timeouts without a specified missing index; elapsed time since a specified index was last used; a computing system automatically collecting at least one value for the metric within a relational database management system; the computing system automatically determining that the collected value satisfies the threshold; and then a computing system automatically implementing the identified index management action without requiring an explicit further user authorization.