SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Chat now with support

Below is a list of available functions within the SQL Optimizer window.

These functions are available only for the original SQL statement <Edit SQL> when displayed in the editable SQL Text window.

Button or Menu	Function
SQL Menu $image\B_Optimize.gif$ $image\B_AbortOptimize.gif$	Optimize/Abort Optimize
SQL Menu $image\B_ShowPlan.gif$	Show Plan
SQL Menu $image\B_ParameterMarkersConvert.gif$	Convert Parameter Markers
File Menu	Open SQL from SQL Repository

These functions are available for original SQL and its alternatives.

Button or Menu	Function
SQL Menu $image\B_RunResult.gif$ $image\B_AbortRunResut.gif$	Run Result/Abort Run Result
SQL Menu $image\B_RunForFirstRecord.gif$ $image\B_AbortRunForFirstRecord.gif$	Run for First Record/Abort Run for First Record
SQL Menu $image\B_RunForAllRecords.gif$ $image\B_AbortRunForAllRecords.gif$	Run for All Records/Abort Run for All Records
Right-click Menu	Plan Help
SQL Menu	Open Optimized SQL
File Menu	Save SQL to SQL Repository
SQL Menu $image\B_InsertUserDefinedSQL.gif$	Add User-Defined SQL
SQL & Right-click Menu $image\B_TestForScalability.gif$	Test for Scalability
Right-click Menu	Create Benchmark Factory Import File

These functions are available only after the original SQL statement has been rewritten or virtual indexes have been generated.

Button or Menu	Function
SQL Menu $image\B_BatchRun.gif$ $image\B_AbortBatchRun.gif$	Batch Run/Abort Batch Run
SQL Menu	Save Optimized SQL
Search Menu	Find SQL. . . /Find Next SQL
$image\B_FirstSQL.gif$ $image\B_PreviousSQL.gif$ $image\B_NextSQL.gif$ $image\B_LastSQL.gif$	First SQL/ Previous SQL/ Next SQL/ Last SQL
Navigate Menu	Go to SQL
Report Menu	Optimized SQL
View Menu	Show Optimization Details
View Menu	Show Batch Run Details
View Menu	Show Open Optimized SQL Details
View Menu	Show Refresh Plan Details