Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
About SQL Optimizer for IBM DB2 LUW 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

Filter Database Objects

ClosedView the Add Database Object Window

When you are selecting database objects from the list of all objects, you can filter the list in order to more quickly locate specify objects.

To filter database objects

  1. Click image\B_Ellipse.gif to open the Add Database Objects window.

  2. In the Schema box, select the schema name where the objects reside.

  3. In the Object type box, select the database object type.

  4. In the Filter box, enter the filtering criteria using the % wildcard to replaces multiple characters. The filter is case sensitive, so you must match the upper or lowercase characters of the database object name.

  5. If you would like to exclude the database objects that meet the filter criteria instead of including them, check the Exclude filter box.

  6. Select the database objects from the list.


Access Plan

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

SQL Formatter

Database Explorer

SQL Scanner

SQL Inspector

SQL Repository

Index Impact Analyzer

Index Usage Analyzer


Access Plan

ClosedView the Access Plan pane

The access plan is a combination of steps the DB2 LUW database optimizer chooses to execute a SQL statement. Each node represents how the database optimizer will physically retrieve rows of data from the database or how the data is prepared. By examining the access plan, you can see exactly how the database executes your SQL statement.

Right-click Menu

The Access Plan pane contains a right-click menu that allows you to perform the following functions:




Sends the access plan in its current view to the printer, to display on the screen (print preview), or to a file.


Copies the access plan to the clipboard.

View Plan

Changes how the access plan is displayed.

Animated Plan Steps

Highlights one-by-one the access plan steps.

Plan Options

Opens the Access Plan Options window so you can select the specific detailed information that is displayed in the access plan. You can also choose to display specific information in individual columns.

Get Help on plan_step

Displays the help text for the currently selected step in the access plan.

Help on Access Plan

Opens online help for the access plan.


Related Topics

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



Figure: Access Plan "As Tree Plan"



Figure: Access Plan "As Plain Language Plan"



Figure: Access Plan "As Graphic Plan"



Figure: Access Plan "As MS Graphic Plan"


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating