Method to help in optimizing a query from a relational data base management system

Claim 3

The method of claim 1, wherein said information is arranged in a table.

Claim 4

The method of claim 1, wherein the RDBMS has objects and said characteristic is associated with one of said objects.

Claim 5

The method of claim 1, wherein said characteristic in said box includes information, said method further comprising: incorporating said characteristic in a button within said box; and clicking on said button to display said information on said screen display.

Claim 6

The method of claim 4, wherein said box incorporating said characteristic includes a table having descriptive elements, and said information includes said descriptive elements.

Claim 7

The method of claim 4, wherein said box incorporating said characteristic is an index, and said related information includes a histogram.

Claim 8

The method of claim 1, wherein the RDBMS has a dictionary including views, each view comprising a query, and said step of generating, further comprises: selecting the query from said views of said dictionary; and displaying the query of said selected view on the screen display.

Claim 9

The method of claim 7, further comprising: displaying the query on the screen display; and modifying contents of the query so that the query execution plan can be optimized by a user.

Claim 10

The method of claim 1, wherein the query is stored in a file, and said step of generating, further comprises: displaying the query of said file on the screen display.

Claim 11

The method of claim 9, further comprising: displaying the query on the screen display; and modifying contents of the query so that the query execution plan can be optimized by a user.

Claim 12

The method of claim 1, further comprising: displaying the query on the screen display; and modifying contents of the query so that the query execution plan can be optimized by a user.

Claim 13

A tool for displaying a query execution plan of a query for a relational database management system (RDBMS), said RDBMS being of the type that processes aspatial data only and having a screen display, wherein the query execution plan comprises operations to be executed by the RDBMS, the operations being interconnected through links, said tool comprising: an input for receiving information representative of the query execution plan, said information including at least one of operation names for the operations of the query execution plan, an option and at least one characteristic of each of the operations; said tool having means for analyzing said information to determine said operation names, said options, said characteristics and said links; and means for displaying on the screen display the operations in respective boxes, each box incorporating said operation name and corresponding option and characteristics and the links between the boxes in linear graphical form.

Claim 14

A tool for displaying a query execution plan of a query for a relational database management system (RDBMS), said RDBMS being of the type that processes aspatial data only and having a screen display, wherein the query execution plan comprises operations to be executed by the RDBMS, the operations being interconnected through links, said tool comprising: an input for receiving information representative of the query execution plan, said information including at least one of operation names for the operations of the query execution plan, an option and at least one characteristic of each of the operations; said tool having means for analyzing said information to determine said operation names, said options, said characteristics and said links; and means for displaying on the screen display the operations in respective boxes, each box incorporating said operation name and corresponding option and characteristics and the links between the boxes in linear graphical form.

Claim 15

The tool of claim 12, wherein said information is arranged in a table.

Claim 16

The tool of claim 12, wherein the RDBMS has objects and said characteristic is associated with one of said objects.

Claim 17

The tool of claim 12, wherein said characteristic in said box includes information, said tool having means for incorporating said characteristic in a button within said box; and said tool having means for providing a user with the ability to click on said button to display said information on said screen display.

Claim 18

The tool of claim 15, wherein said box incorporating said characteristic includes a table having descriptive elements, and said information includes said descriptive elements.

Claim 19

The tool of claim 15, wherein said box incorporating said characteristic is an index, and said information includes a histogram.

Claim 20

The tool of claim 12, wherein the RDBMS has a dictionary including views, each view comprising a query, said tool including means for selecting the query from said views of said dictionary, and means for displaying the query of said selected view on the screen display.

Claim 21

The tool of claim 18, wherein said tool displays the query on the screen display, and modifies contents of the query so that the query execution plan can be optimized by a user.

Claim 22

The tool of claim 12, wherein the query is stored in a file, and said tool displays the query of said file on the screen display.

Claim 23

The tool of claim 20, wherein said tool displays the query on the screen display, and modifies contents of the query so that the query execution plan can be optimized by a user.

Claim 24

The tool of claim 12, wherein said tool displays the query on the screen display, and modifies contents of the query so that the query execution plan can be optimized by a user.