Patent ID: 8626729

Claim:
A method performed by a server computer comprising: executing, using the server computer, a set of jobs to analyze operations of application databases and to populate index monitoring files, with the index monitoring files including an index list, index status information, query statement information and index usage information; outputting the index list, using the server computer and in response to a request from a client computer, for display on a display device of the client computer, with the index list including a list of identifiers corresponding to different indexes; outputting the query statement information, using the server computer and in response to a request from the client computer, for display on the display device of the client computer, with the query statement information being about types of query statement used to access a particular index, performance characteristics of a given query statement, and whether a given query statement executed a full table scan of one or more tables of one or more application databases; outputting the index status information, using the server computer and in response to a request from the client computer, for display on the display device of the client computer, with the index status information including status identifiers describing each index; outputting the index usage information, using the server computer and in response to a request from the client computer, for display on the display device of the client computer, with the index usage information for a particular index including one or more of information about how many times database query statements used the particular index, a period of time during which the particular index was used, whether the particular index was used for a first time during the period of time, the type of a particular database query statement that used the particular index, how many times any one or more database query statements accessed the particular index, how many times a particular type of database query statement accessed the particular index, whether the particular database query statement resulted in a full table scan, and query statement performance; and outputting index removal criteria information, using the server computer and in response to a request from the client computer, for display on the display device of the client computer, with the removal criteria information based on one or more of the index list, index usage information, index status information or query statement information and with the index removal criteria information listing pre-determined criteria based on frequency of use of an index and performance of queries that use the index.