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.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
