Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

Index Expert Functions

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

Button or Menu

Function

SQL Menu

image\B_GenerateIndexes.gif image\B_AbortGenerateIndexes.gif

Generate Indexes / Abort Generate Indexes

SQL Menu

image\B_IndexSimulator.gif

Simulate Indexes

SQL Menu

image\B_ShowPlan.gif

Show Plan

SQL Menu

image\B_RunResult.gif

Run Result

SQL Menu

image\B_RunForAllRecords.gif

Run for All Records

SQL Menu

image\B_RunForFirstRecord.gif

Run for First Record

SQL Menu

image\B_BatchRun.gif image\B_AbortBatchRun.gif

Batch Run / Abort Batch Run

SQL Menu

image\B_ImpactAnalysis.gif

Impact Analysis

SQL 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

Navigate Menu

Go To Index Set

Edit Menu

image\B_SendToSQLOptimizer.gif

 

Send to SQL Optimizer

File Menu

image\B_SaveSQLtoSQLRepository.gif

Save SQL to SQL Repository

View Menu

Show Index Generation Details

View Menu

Show Batch Run Details

 

Related Documents