Patent ID: 6744449
Filing Date: 2004-06-01
Classification: G06F,Y10S

Abstract:
A computer based method for providing a graphical cost analysis of a plurality of user specified queries, the computer based method comprising:a. determining an optimal execution plan for one of the user specified queries; b. displaying on a display device a tree structure representation of the one of the user specified queries, the tree structure representation comprising icon nodes connected by arrow representations, the icon nodes each corresponding to one of query operations which comprise the execution plan, each arrow representation having a width bearing a mathematical relationship to an execution cost of one of the query operations corresponding to an icon node from which the arrow representation originates; c. checking for user selection of one of the icon nodes via a user input device; d. in the event of user selection of one of the icon nodes, displaying on the display device additional cost statistics for the query operation corresponding to the one of the icon nodes selected; and e. repeating steps a-d until the steps have been performed for each of the plurality of user specified queries.