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

Right Pane for Analyzed Table Information

In the Index Usage Analyzer window, when a table is selected under the Tables Analyzed section is selected in the left pane, the following information displays in the right pane.

Prognosis Button

Item Description

Top Pane - Summary Information

Displays a summary of the indexes in the table that are used or unused.

Middle Pane - Index Used Information

Displays the indexes used by the SQL statement.

Bottom Left Pane - SQL Text

Displays the text of the SQL statement.

Bottom Right Pane - SQL Information

Displays the query plan, abstract plan, traceon information, SQL Classification, and the temporary table DDL for the selected SQL statement in the SQL Information Pane.

Unused Index Button

Lists the indexes and the key for all indexes in the table that are not used. Use the Right-click menu to Save the list of indexes or Drop Index.

Table Information Button

Item Description

Definition Tab

Displays when and where the table was created.

Columns Tab

Displays the column information for the table.

Index Tab

Displays the index information for the table.

DDL Tab

Displays the DDL for creating the table and indexes.

 

Related Topic

Right Pane for SQL Analyzed Folder

In the Index Usage Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.

Index Used

Displays all the SQL statements and shows the tables and indexes used.

 

Related Topic

Right Pane for SQL Statements

When a SQL statement is selected in the left pane, the following information displays in the right pane.

Properties button

Displays general information about the analysis, information on the connection used to retrieve the query plans and the database settings at the time of the analysis.

SQL Information button

Displays the query plan and the SQL Information pane.

Index Used button

Displays the table name, the index name, and the index key for the indexes used by the SQL statement. Use the Right-click menu to Save the list of indexes.

 

Related Topic

Create an Index Usage Analysis

Related Documents