Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

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

Related Documents