Patent ID: 7974973

Claim:
A method for displaying information related to performance of a database during a time interval, the method comprising: a) during the time interval, effecting a plurality of index I/O operation or table I/O operation detectings, each index I/O operation or table I/O operation detecting being associated with a respective quantity of wait-time; b) for each index I/O or table I/O operation detecting of the plurality of index I/O or table I/O operation detectings: i) determining an identity of a respective target index or table for the detected index I/O or table I/O; ii) determining an identity and an execution plan of a respective invoking database statement; iii) determining a respective database index-execution plan relationship or database table-execution plan relationship between the respective target index and the execution plan of the respective database statement; and iv) categorizing, in accordance with the index-execution plan or table-execution plan relationship, the detected table or index I/O operation into an I/O category selected from a plurality of I/O categories; c) in accordance with: i) the wait-time quantities; and ii) the results of the categorization, determining, for a particular category of the plurality of I/O categories, for a given index or table of the database and for the time interval, a fractional aggregate index-I/O or table I/O wait time for the particular category, the fractional aggregate index-I/O or table I/O being only a fraction of a total index IO wait time or table I/O wait time for the given index or table for the time interval; and d) in accordance with the determine fractional aggregate index-read wait time for at least one of the categories, presenting, to a user, a description of performance of the database during the time period.