SQL Optimizer for SAP ASE 3.9.1

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

Batch Run

Determine Best Performing Index Alternative

Index Advisor > 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

Click $image\B_BatchRun.gif$ .
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.
In the Batch Run Criteria window, select the Batch Run criteria from the following tabs and click OK.

Selected Index Set
SQL Termination
Batch Termination
Run Time Mode
Batch Run Schedule

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$ .

Create Indexes for Batch Run

Index Advisor > Batch Run > 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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Index Advisor Functions

Batch Run

Determine Best Performing Index Alternative

Create Indexes for Batch Run