SQL Optimizer for SAP ASE 3.9.1 - Release Notes

View Particular Types of SQL Statement

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.

Related Topics

SQL Collector for Monitor Server Overview

SQL Collector Window