サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

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"

 

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択