Computer program product and system for annotating a problem SQL statement for improved understanding

[0036]the present invention provides a computer program product that derives the data content and format as displayed in graphical display window 201. More specifically, the computer program product of the present invention receives problem SQL statement from any one of a number of possible sources, where one possible source is the application program 20 as depicted in FIG. 1. Other possible sources of problem SQL statements include: statement lists generated by the DBMS 40, such as by an internal monitoring tool, a dynamic statement cache, or an external query reporting tool. Still other possible sources include, but are not limited to: database catalogs, alternate forms generated by SQL optimizers, or even statements that have been manually entered or copied into a text field.

[0037]After the computer program product of the present invention receives the problem SQL statement, the computer program product parses this statement into a plurality of separate clauses and formats these cla

[0042]the present invention provides a system 400 for analyzing the problem SQL statement 301 shown in FIG. 3. This inventive system 400 is illustrated in FIG. 4. The following description refers to FIGS. 1 through 4.

[0043]A SQL optimization module 401, such as for example, a particular application program 20 executing at the user interface 10, receives a problem SQL statement 301 and transforms the problem SQL statement 301 into an alternate form 41 which may be more efficient. This alternate form 41 includes suggested changes to at least one of the query clauses of the original SQL problem statement 301. The alternate form SQL statement 41 is sent from the SQL optimization module 401 to a text processing module 402.

[0044]Text processing module 402 parses the alternate form SQL statement 41 into a plurality of alternate query clauses and formats these alternate clauses into a hierarchical tree structure 42 including one alternate SQL query clause per indented line. The text processing