Patent ID: 7792849

Claim:
A method for comparing at least two database items, the method comprising the steps of: providing a graphical user interface that allows a user to select the at least two database items for comparison, each database item including a plurality of database statements; eliminating database statements in the at least two database items that have an average runtime less than a specified threshold; comparing the at least two database items; and displaying results of the comparison in a graphical format in a ranked list of database statements, the ranked list further including for each database statement in the ranked list: maximum open time, maximum fetch time, maximum close time, statement usage count, average table scans, average indexes used, full indexes created, sparse indexes created, indexes from index created, average index creates advised, average temporary tables, average sorts, average bitmap creates, average materialized query tables used, maximum table rows, maximum estimated rows, maximum rows returned, and average table rows.