Patent ID: 7974969

Claim:
A method for displaying information related to performance of a multi-index database having a plurality of indexes during a time interval, the method comprising: a) for each index-read detecting of a plurality of index-read detectings that occur during the time interval: i) determining an identity of the target index and a data-writing triggering data-writing database statement of the detected index-read; i) quantifying a respective amount of wait time associated with the index-read detecting; and iii) in accordance with an execution plan of the triggering data-writing database statement, classify the detected index-read as either a performance-accelerating index-read or an overhead index-read; b) for each index of a plurality of indexes of the database, determining, in accordance with results of the quantifying and classifying operations, a respective aggregate index overhead wait time for the time interval; and c) in accordance with one or more of the determined index overhead wait times, presenting, to a user, data describing performance of the database during the time interval.