Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

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

Related Documents