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

Options

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

 

About Options

To change an Options setting

Click image\B_Options.gif to specify the desired settings.

When you change the settings, your latest settings are always saved and restored each time to exit and restart the program. You can also save several sets of option settings either by saving settings from one or more tabs or by saving all the option settings.

To save specific settings so that you can use them later

  1. In the Options window, click Save.

  2. Enter a filename for the saved settings. Click Save.

  3. From the Save Options Profile window, select the tabs for the settings you want to save. Click OK.

To restore the saved settings

  1. In the Options window, click Load.

  2. In the Open File window, select the filename. Click Open.

  3. From the Save Options Profile window, select the tabs for the settings you want to load.

     

The Options window is divided into the following tabs and pages:

Optimization

Optimization Intelligence

Optimization (1)

Optimization (2)

SQL Options

Quota

General

Editor

Activity Log

Plan

SQL Scanner

Options

General

SQL Classification

Directory Setup

Linkage

General

General

Message

Result Set

 

SQL Rewrite Settings

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

 

SQL Rewrite Settings

The SQL Rewrite tab on the Options window consists of several pages that are selected from buttons on the left. These settings allow you to select the optimization level and other options that the SQL Rewrite function uses to create alternatives for your SQL.

The settings include the following:

Intelligence

SQL Rewrite (1)

SQL Rewrite (2)

SQL Options

Quota

General

 

Related Topics

Related Documents