Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

SQL Optimizer Functions

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

 

Related Documents