Patent Number: 6,434,545

Title: Graphical query analyzer

Abstract: A user specifies one or more queries comprising a batch of SQL statements. Each query submitted is displayed and represented as a tree, with each operation in the execution plan for the query represented by a corresponding tree node. This representation intuitively conveys the DBMS execution strategy which would be used to process the queries. The tree nodes are displayed as icons, with a unique one of such icons corresponding respectively to each of the possible query operations. In addition, the computing cost of each operation (each node) as a percentage of overall query cost is displayed, as is the cost of each query as a percentage of the overall cost of the specified query batch. A user may select an operation (tree node) with a conventional mouse, whereupon a user interface will show more detailed cost statistics relating to the selected operation.

Inventors: MacLeod; Stewart P. (Redmond, WA), Kiernan; Casey L. (Kirkland, WA), Vasandani; Manu (Bellevue, WA)

Assignee: Microsoft Corporation

International Classification: G06F 17/30 (20060101); G06F 017/00 ()

Expiration Date: 08/13/2019