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

Index Advisor Functions

Below is a list of available functions within the Index Advisor window.

Button or Menu

Function

Index Menu

image\B_AdviseIndexes.gif image\b_AbortAdviseIndexes.gif

Advise Indexes / Abort Advise Indexes

Index Menu

image\B_UserDefinedIndex.gif

User-Defined Index

Index Menu

image\B_ShowPlan.gif

Show Plan

Index Menu

Show Default Plan

Index Menu

image\B_BatchShowPlan.gif

Batch Show Plan

Index Menu

image\B_RunResult.gif

Run Result

Index Menu

image\B_RunForFirstRecord.gif

Run for First Record

Index Menu

image\B_RunForAllRecords.gif

Run for All Records

Index Menu

image\B_BatchRun.gif image\B_AbortBatchRun.gif

Batch Run / Abort Batch Run

Index Menu

Create Indexes

Index Menu

image\B_ClearAllIndexSets.gif

Clear All Index Sets

Navigate Menu

image\B_FirstSQL.gif image\B_PreviousSet.gif image\B_NextSet.gif image\B_LastSQL.gif

First Set, Previous Set, Next Set, Last Set

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopyToSQLWorksheet.gif

Copy to SQL Worksheet

View Menu

Show Index Advising Details

View Menu

Show Batch Run Details

 

Related Topics

Batch Run

Determine Best Performing Index Alternative

After you generated Index candidates or created Index Sets for your original SQL statement in the Index Advisor window, you need to determine which indexes give you the best performance. The Batch Run function is used to retrieve the run time of the original SQL statement for different index candidates or set.

To setup and execute the Batch Run

  1. Click image\B_BatchRun.gif.

  2. The Create Indexes for Batch Run window displays. Select the segment where the index will be created and specify the number for the consumers. Click OK.

  3. In the Batch Run Criteria window, select the Batch Run criteria from the following tabs and click OK. 

The Batch Run dialog field displays the run time criteria and the current run time of the SQL statement for each Index Set as it is retrieved.

Note: The indexes are physically created on the database, the query plan is retrieved, and then the indexes are dropped. This process may affect other SQL statements executing on the database during this period.

To terminate the running of the SQL statement under the current Index set

Select SQL | Stop Current.

To terminate the Batch Run process

Click image\B_AbortBatchRun.gif.

 

Related Topic

Create Indexes for Batch Run

The Create Indexes for Batch Run window displays when you execute the Batch Run or Batch Show Plan function. It enables you to specify how you would like the indexes created:

Item

Description

Segment

Select the segment where you would like the index created from the drop-down list.

Consumer

(Default 1 Range 1-20)

Specify the number of consumer processes that should perform the sort operation for creating the index. The actual number of consumer processes used to sort the index may be smaller than the specified number, if fewer worker processes are available when Adaptive Server executes the sort.

 

Related Topic

Related Documents