After the SQL statements are captured, all the SQL statements found in the selected Collector are displayed. However, you can restrict the SQL statements shown by selecting the type of SQL statement by selecting the menu items available under the View menu. The SQL Collector window's title bar displays your chosen option. You can view one or more types of SQL statement by selecting or clearing the menu items.
To display the simple SQL statements
Select View | Simple SQL.
To display the complex SQL statements
Select View | Complex SQL.
To display the problematic SQL statements
Select View | Problematic SQL.
To display the SQL statements without a query plan
Select View | SQL without Plan.
To display all SQL statements
Select View | All SQL.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center