SQL Optimizer for DB2 LUW - Knowledge Base

User Guide > Copy Column Names to Another Window

To facilitate the construction of an SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows. ... A new line and a comma will separate each column name when it is copied to the editor pane of the other module.

User Guide > User Logon Screen

When you start SQL Optimizer, a User Logon dialog box is displayed to allow connection to the DB2 database. ... In the Login Name box, enter the user name required to connect to the database. ... In the Password box, enter the password associated with the user name.

Installation Guide > Retrieve Run Result

If the SQL statement contains a result set, the SQL Result window displays, showing all data retrieved. ... Otherwise, an information dialog box showing the number of rows affected displays. ... In the SQL Result window, the first rows of the result set are displayed as soon as they are returned from the database.

User Guide > Check Scanned SQL

After scanning is completed, you can review the scanned SQL statement in the Scanned SQL Viewer window. ... It is recommended that you look at Problematic SQL, followed by Complex SQL. ... After you have reviewed a scanned SQL statement you can mark the SQL as checked.

Installation Guide > SQL Optimizer for DB2 LUW Overview

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.

User Guide > Execute Result Page

The Execution Result tab in the SQL Optimizer window compares the data returned by the original SQL with the data returned by any one of the SQL alternatives. ... From the SQL list, select the SQL alternative that you want to compare with the original SQL.

User Guide > Scan Source Code with Temporary Tables

During scanning, if the scanned SQL statement is used to create or modify a temporary table, the SQL will be automatically executed if the Create Scanner Temp Table checkbox in the Options is selected.

Release Notes > Inspect

After adding or modifying an Inspector in the SQL Inspector window, SQL statements and statistics from the database are retrieved by executing the Inspect function. ... Only one Inspector can be started at a time.

User Guide > SQL Optimizer for IBM® DB2® LUW

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.

Installation Guide > Scanned SQL Viewer Window

Job list ... The Job list at the top of the Scanned SQL Viewer window displays the Job description of the selected Job and contains the list of Jobs that satisfy the view criteria. ... Scanned SQL (Top Pane)

User Guide > About SQL Functions

SQL Functions are available in evaluating index-set and SQL alternatives. ... Show Plan

Installation Guide > General Settings

The General tab on the Options window consists of 3 buttons that allow users to specify settings used throughout the program.

Installation Guide > SQL Repository Functions

Below is a list of available functions within the SQL Repository window. ... Function

Installation Guide > Copy Data from Cells, Rows, or Columns

You can copy the data from a single cell, a row, or a column into the Windows clipboard from the Database Explorer and the Parameters windows. ... Select the table or view name displayed on the tree diagram in the left pane of the Database Explorer window.

Installation Guide > General (SQL Scanner Tab)

The General page on the SQL Scanner tab of the Options window allows you to specify your options for the graphical interface and the Checked SQL feature in the SQL Scanner. ... When checked, the SQL statements are displayed with color-coded tabs representing the SQL’s classification.

Installation Guide > Right Pane for Tables Analyzed

In the Index Usage Analyzer window, when the Tables Analyzed is selected in the left pane, the following information is displayed in the right pane. ... Provides a summary of the use of indexes for each table.

Release Notes > Activity Log Settings

The Activity Log tab on the Options window allows users to specify whether to record the access plan generation and optimization activities during daily operations. ... Activities to be logged ... The Activity log will record the activities from SQL optimization process and retrieval of an access plan.

Release Notes > Create Benchmark Factory Import File

All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. ... These SQL statements can then be imported into Benchmark Factory 4.6 or later.

Release Notes > Right Pane for Analyzed Table Information

In the Index Usage Analyzer window, when a table is selected under the Tables Analyzed section is selected in the left pane, the following information is displayed in the right pane. ... Prognosis Button

User Guide > SQL Scanner 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.

Installation Guide > General (Optimization Tab)

The General page under the SQL Rewritetab in the Options window provides the option to start a Batch Run immediately after the SQL Rewrite process is finished. ... Batch Run ... Batch Run ... Description

User Guide > Scan Inspector

The SQL statements collected by the Inspector can be scanned in the SQL Scanner to classify the SQL statements to help identify which SQL statements are likely to be causing performance problems.

Installation Guide > Troubleshoot SQL Optimizer

Installation Guide > DeleteTemporary Tables

After the User-Defined temporary tables are created, you can delete them. ... Click . ... Select the Temp Table List tab. ... If you want to remove all temp tables, click Drop All Table. ... Otherwise, select the desire temp table from the Temp Table list and then click Drop Table.

Installation Guide > Database Explorer Tutorial

The Database Explorer displays detailed information about database objects including columns, indexes, keys, statistics, DDL, procedure text, and data from the tables. ... Click . ... The left pane of the window displays database objects that relate to your user logon.