Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Open in SQL Collector

SQL Scanner > Open in SQL Collector

In the SQL Scanner if the Job is a Collector file, you can open the Collector file in the SQL Collector window to view the SQL statements.

To open the SQL Collector window

Right-click the job that want to open in the Job List pane and select Open in SQL Collector.


Related Topics

Open in SQL Inspector

SQL Scanner > Open in SQL Inspector

In the SQL Scanner if the selected Job is an Inspector file or the selected SQL statement, you can open the Inspector file in the SQL Inspector window to view the statistics and charts.

To open the SQL Inspector and display the statistics

Right-click the job that want to open in the Job List pane and select Open in SQL Inspector.


Related Topics

Create Benchmark Factory Import File

SQL Repository > Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory 4.6 or later.

To create a file to import into Benchmark Factory

  1. Right-click and select Create Benchmark Factory Import File.

  2. Select the specific SQL statements that you want to save.

  3. Enter the filename and select the file location.


View a Particular SQL Type

SQL Scanner > View a Particular SQL Type

In the SQL Scanner window, initially 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 SQL Scanner window displays the chosen criteria. One or more types of SQL statements can be viewed by selecting or de-selecting the menu items.:

To display SQL statements

Select View | option.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating