SQL Optimizer for SAP ASE 3.9 - Release Notes

What files does SQL Scanner scan?

The SQL Scanner extracts SQL statements from the following:

Database Objects

Database objects with embedded SQL statements. This includes: stored procedures, triggers, views, rules and defaults. Depending on your database privileges, the available database objects can be selected by object name, object type, or user name.

Abstract Plan Groups

SQL statements saved in abstract plans.

SQL Collector for Monitor Server Files

SQL statements captured in the SQL Collector for Monitor Server module during execution.

SQL Inspector Files

SQL statements retrieved in the SQL Inspector module from the Adaptive Server monitoring tables.

Text/Binary Files

Text and binary files that contain embedded SQL statements.

COBOL Files

COBOL source code that contain embedded SQL statements.

Note: If your SQL statements are dynamic SQL statement generated on the fly or at run time, you can use the SQL Collector for Monitor Server to capture the SQL statements. Then the SQL Scanner can be used to analyze the captured SQL statements.

Related Topics

SQL Scanner Overview

Add Jobs to SQL Scanner