Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating