Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - 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

SQL Scanner Window

The SQL Scanner window has 3 panes, a status bar and a toolbar. 

Job List Pane

The grid from the SQL Scanner window stores information on each individual Job in the Group. It displays the following: 

Column Heading Description

File / Database Object

Checkbox

Indicates if the job is selected

Type of job icon and text

image\I_DatabaseObject.gif[Database] [User] Object type -> Object type

image\I_Text-Binary.gif[Database] [User] Text/Binary -> Path/File Name

image\I_COBOL.gif[Database] [User] COBOL -> Path/COBOL File Name

image\I_AbstractPlan.gif[Database] [User] Group -> [Database] [User] APGroup -> Abstract Plan Group

image\I_Monitor.gif Collector -> Collector Name

image\I_Inspector_blue.gif Inspector -> Inspector Name

Status

Displays the current Job status. This column is blank until the Job is scanned. After the Job is scanned it displays the number of SQL statements found.

Valid SQL

Displays the number of valid SQL statements found in the Job. Valid SQL statements are syntactically correct statements recognized by the SQL Scanner, and for which Adaptive Server can provide a query plan. Valid SQL statements are further classified as Simple, Complex and Problematic SQL statements.

Problematic SQL

Displays the number of Problematic SQL statements found.

If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Problematic SQL that have not been checked and the other (enclosed in brackets) is the number of Problematic SQL that have been checked. The total of these two figures represents the total number of Problematic SQL statements.

Complex SQL

Displays the number of Complex SQL statements found.

If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Complex SQL that have not been checked and the other (enclosed in brackets) is the number of Complex SQL that have been checked. The total of these two figures represents the total number of Complex SQL statements.

Simple SQL

Displays the number of Simple SQL statements found.

If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Simple SQL that have not been checked and the other (enclosed in brackets) is the number of Simple SQL that have been checked. The total of these two figures represents the total number of Simple SQL statements.

File Size

Displays the size of the Job in bytes.

Started At

Displays the date and time when the scanning the Job began.

Processing Time

Displays the total time taken to scan the Job. The time displays in the HH24:MI:SS format.

SQL Text Pane 

The left pane of the SQL Scanner window displays the scanned SQL statement for a particular scan Job. The SQL statement is formatted according to SQL Formatter’s indentation algorithm. If more than one SQL statement is found in a Job, there are multiple tabs at the bottom of this pane for selecting the SQL. The tabs are color-coded to the SQL type classification if the Use color tabs for SQL classification option is selected in the Preferences window. Problematic SQL is red. Complex SQL is purple. Simple SQL is green. Invalid SQL is blue. Checked SQL is grey.

SQL Information Pane

The SQL Information Pane provides detailed information about the SQL statement.

Status Bar

The Status Bar at the bottom of the SQL Scanner window contents the following information:

Item Description

Data Directory

Directory path where all the data files produced during scanning are saved. The data directory path can be changed in the Preferences window. While scanning, a progress bar displays to show scanning progress. The upper bar shows the current job progress, while the lower bar shows the total Job status.

Group

Name of the currently opened Scanner Group.

Total Jobs

Total number of Jobs.

Completed

Total number of Jobs already scanned.

Remaining

Total number of Jobs that have not been scanned.

 

Related Topics

Group Manager Window

A scanner Group is used to store Jobs (files, database objects, abstract plan groups, Inspectors, or Collectors from the SQL Collector for Monitor Server). The Group Manager window is used to create, open, delete, and rename these Groups. It also displays a list of existing Groups. A Group is opened in the SQL Scanner window. The Group Manager provides the following functions:

Function Description

Open

Opens the selected Group in SQL Scanner window.

Create

Creates a new Group.

Modify

Modifies selected Group name or description.

Delete

Deletes the selected Group and all associated files.

Note: All Group information is stored as files in the SQL Scanner data directory defined in the Preferences window.

 

Related Topics

View Group Summary

The Group summary report provides a statistical list and charts of all the Jobs and SQL statements scanned within the Group.

To view the report

With the SQL Scanner window as the active window, select Report | Group Summary.

 

Related Topics

View Group Properties

To view the Group properties In the Group Manager window

Right-click a Group and select Properties.

Review the following for additional information:

General tab

 

 
Item

Description

Name

Group name.

Description

Group description.

Last modified

Last modified date and time.

Size

Number of bytes of disk space used to store the Job information.

Data Directory

Directory where the files are stored.

Version

Version number of SQL Optimizer when the Group was created.

Total Job

Total number of Jobs.

Completed

Total number of Jobs that were scanned.

Remaining

Total number of Jobs that had not been scanned.

SQL Summary tab

Displays a pie chart showing the number and percentage of Problematic, Complex, Simple and invalid SQL statements.

 

Related Topics

Related Documents