Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

SQL Optimizer for SAP ASE 3.9 - Release Notes

Table of Contents

Release Notes Product Licensing

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

Index Advisor Overview

Index Advisor Window

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating