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

Review Access Plans

The access plan can be displayed in different ways to help you get a clear picture of the steps or detailed information about the steps that DB2 LUW is taking to execute a SQL statement.

For each location where the access plan is displayed, it will remember the display view option (As Tree Plan, As Plain Language Plan, As Graphic Plan, or As MS Graphic Plan) that you have selected from the right-click View Plan option. It will use that option the next time you view the access plan in the same location in the program.

To change how the access plan is displayed

  1. Right-click the Access Plan pane and select View Plan.

  2. Select one of the following display options:

    As Tree Plan

    As Plain Language Plan

    As Graphic Plan

    As MS Graphic Plan

 

image\M_QSOU_AsTreePlan.gif

Figure: Access Plan "As Tree Plan"

 

image\M_QSOU_AsPlainLanguagePlan.gif

Figure: Access Plan "As Plain Language Plan"

 

image\M_QSOU_AsGraphicPlan.gif

Figure: Access Plan "As Graphic Plan"

 

image\M_QSOU_AsMSGraphicPlan.gif

Figure: Access Plan "As MS Graphic Plan"

 

Access Plan Options

The display of the Access Plan options can be customized for each window in which the access plan is displayed. You can select which elements of the access plan you would like displayed. You can also have the elements displayed in separate columns.

To customize the Access Plan window

  1. Right-click the access plan and select Plan Options.

  2. In the Visible column, select the elements you want displayed in the access plan text.

  3. In the As Column column , select the elements for which you want a column added to the display in the Access Plan.

When you are viewing the access plan in plain language, you can also display any of the elements in a column.

To include elements when viewing the access plan in plain language

  1. Right-click the access plan and select Plan Options.
  2. In the As Column column, select the elements for which you want a column added to
  3. the display in the Access Plan.

Note: The color and font settings for the access plan are set on the Plan tab in the Options window.

 

Access Plan Functions

The following functions are available from the button pane at the right edge of the access plan pane:

Button

Action

Description

image\B_GoToFirstStep.gif

Go to First Step

Highlights the first execution step.

image\B_GoToPreviousStep.gif

Go to Previous Step

Highlights the previous execution step.

image\B_GoToNextStep.gif

Go to Next Step

Highlights the next execution step.

image\B_ShowPlanDetail.gif

Show Plan Detail

Displays the Plan Detail window. The information displayed is dependent on the highlighted row.

 

Plan Detail

The Plan Detail window provides detailed information on the selected node of the access plan and the relating object details.

To display the Plan Detail

  1. Click a node of the access plan.

  2. Click image\B_ShowPlanDetail.gif located on the right edge of the Access Plan pane.

Object Details

The Object Details tab displays statistics about the selected access plan step. You will see the specific values from the selected step in the DETAILS column. Or, if the selected access plan step is performing an action using the table or index, statistics for the table or index are displayed in two columns: EXPLAINED and CURRENT. The EXPLAINED column displays the statistics retrieved at the time the access plan was retrieved. The CURRENT column displays the current statistics that are retrieved when the Plan Detail window was opened.

Optimization Parameters

The Optimization Parameters tab displays the DB2 database parameters values that were set in DB2 LUW at the time the access plan was retrieved.

Table/View Detail

To see the table or view details, click the table or view name in the left pane of the Plan Detail window. Then click one of the four tabs at the bottom of the right pane to see specific information about the definition, columns, indexes, or data for the table or view. If you have the appropriate privileges, you can modify the data under the Data tab.

 

Related Documents