When the Scanned SQL Viewer window is first opened all SQL statements in the selected Job are shown. Customization of the view allows the displaying of: All, Simple, Problematic, Complex, and/or Invalid SQL statements. In addition, you can view the Checked and/or Unchecked SQL statements. The title bar of the Scanned SQL Viewer window displays the chosen criteria. One or more types of SQL statements can be viewed by selecting or de-selecting the menu items. The Job list contains all the Jobs using the chosen view criteria:
To display all SQL statements
Select View | All SQL.
To display the Simple SQL statements
Select View | Simple SQL.
To display the Problematic SQL statements
Select View | Problematic SQL.
To display the Complex SQL statements
Select View | Complex SQL.
To display the invalid SQL statements
Select View | Invalid SQL.
To display SQL statements with different bound and new access plan that satisfy the selected SQL classification type
Select View | Different Bound and New Access Plan.
To display SQL statements with no bound access plan that satisfy the selected SQL classification type
Select View | No Bound Access Plan.
To displays all Checked SQL statements
Select View | Checked SQL.
To displays all Unchecked SQL statements
Select View | Unchecked SQL.
There are several ways to navigate through the Jobs in the Scanned SQL Viewer window:
Double-click the Job to be viewed in the Job Manager window.
Select the Job from the Job list.
Use the navigation buttons on the toolbar or corresponding menu items.
Button |
Menu Item |
Description |
---|---|---|
|
Display the first Job. | |
|
Display the previous Job. | |
|
Display the next Job. | |
|
Display the last Job. |
To generate a report for scanned SQL statements
With the Scanned SQL Viewer window open select Report | Scanned SQL to open the Scanned SQL Report Criteria window.
Select the report criteria.
The information in the report can be saved or printed.
Note: A few minutes may be needed to generate a long report.
All the SQL statements can be saved in a text file from the Job Manager, the Scanned SQL Viewer, the SQL Repository, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory program (version 4.6 or later).
To create the text file to import into Benchmark Factory
Right-click and select Create Benchmark Factory Import File.
Select the specific SQL statements that you want to save. Click OK.
Enter the filename and select the file location. Click Save.
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center