Patrick D. Bossman - Alexandria VA, US Chih Jieh Chang - San Jose CA, US Gene Fuh - San Jose CA, US Tracy Ho - San Jose CA, US Chan-hua Liu - San Jose CA, US Kevin M. McBride - Mountain View CA, US Xinyu Wang - Beijing, CN
International Classification:
G06F 17/30
US Classification:
707102
Abstract:
A computer program product and system are disclosed for parsing a problem SQL statement into query clauses, formatting these query clauses into a hierarchical tree structure, generating performance statistics for clauses that have associated performance statistics and displaying the formatted SQL statement with each clause contained on a separate display line annotated with its corresponding associated performance statistics on the same display line and with the hierarchical tree structure represented by indention levels of the separate display lines.