Apparatus and method for a graphical user interface to facilitate tuning sql statements

An apparatus for tuning SQL, comprising:

• a display module configured to present a set of SQL statements associated with a particular relational database;
• a selection module configured to allow a user to select a SQL statement for tuning from the set of SQL statements and one or more SQL tuning advisors to be applied to the selected SQL statement;
• and
• an execution module configured to generate a first prioritized SQL advisor summary based on the one or more user selected SQL tuning advisors applied to the user selected SQL statement to determine performance characteristics of the SQL statement, the first prioritized SQL advisor summary containing an advice summary for each of the user selected SQL tuning advisors, the advice summary including a visual advisor priority status indicator, the execution module is further configured to generate, when the user selects a first user interface component in the first prioritized SQL advisor summary, recommended action details containing advisor specific SQL tuning recommendations for a selected advisor from the SQL advisor summary, the recommended action details being displayed to the user on the display module, the execution module is further configured to execute an advisor specific SQL tuning process when the user selects a second user interface component presented in the recommended action details and to display a second advisor specific SQL advisor summary containing advice summaries based upon the identified SQL statement after executing the advisor specific SQL tuning process on the display module, the advice summaries presented such that higher priority advice summaries are addressed by a user before lower priority advice summaries.

A system for tuning SQL, comprising a computer processor, at least one memory device in communication with the processor via a system bus, a display device in communication the system bus, and a user input device in communication with the system bus, the system for tuning SQL being configured to:

• present a set of user selectable SQL statements associated with a particular relational database on the display device;
• receive a user selected an SQL statement for tuning and user selected SQL tuning advisors from the user input device;
• generate, with the processor, a prioritized SQL advisor summary based on the user selected SQL tuning advisors applied to the SQL statement for tuning to determine performance characteristics of the SQL statement for tuning, the first prioritized SQL advisor summary being displayed the user with the display and containing a visual advisor priority status indicator for each of the user selected SQL tuning advisors;
• generate, with the processor and when the user selects a first user interface component in the prioritized SQL advisor summary, recommended action details containing advisor specific SQL tuning recommendations for a selected advisor from the SQL advisor summary, the recommended action details being displayed to the user on the user device;
• execute, with the processor, an advisor specific SQL tuning process when the user selects a second user interface component presented in the recommended action details with the input device;
• and
• generate, with the processor, a revised advisor specific SQL advisor summary containing prioritized SQL tuning advisors based upon the identified SQL statement after executing the advisor specific SQL tuning process and displaying the second advisor specific advisor summary to the user on the display device.