SQL Optimizer for DB2 LUW 5.0 - User Guide

Preference Settings for Handling Temporary Tables

Under the Options window, the SQL Scanner and Optimization tabs contain several settings that control the use of temp tables in the SQL Scanner and SQL Optimizer modules.

SQL Scanner Tab - Options Button

Create Scanner Temp Table

Include data

Override previous Scanner Temp Table

Optimization Tab - Optimization Button

Temp table generation

Apply selected SQL Options to temp table SQL

Related Topics

User-Defined Temp Table Overview

Editor Functions

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. 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 Editor Functions

Editor functions are available on all editable windows to help format and construct SQL statements. The layout of the SQL statement is important to make it easier to read and maintain particularly when dealing with large and complicated SQL statements.

Editor functions settings can be changed within the Options window under the Editor tab.

Auto Correction

Auto correction automatically corrects any typo and spelling errors, if the auto correction option is turned on. For example, if " teh " is typed followed by a space, it will automatically be corrected to "the". Auto correction entries are user-defined and can be modified in the Options window.

To setup auto correction

1. Click .

2. Select the Editor tab.

3. Under the Editing section, click next to the Auto Correction checkbox to open the Auto Correction Settings window.

4. Modify the auto correction entries

5. Click Apply.

6. Click OK.

7. Check the Auto Correct checkbox in order for auto correction function to be enabled.

The available auto correction entries are listed on the list box. Each entry has a Replace text (the original text typed) and With text (the replacement text).

Action keys are the keys that will activate the auto correction. When you type the Replace text and follow it by any action key, the replacement takes place. No whitespaces are needed to separate each key. By default, the action keys are ";,:=[]\ n\t\s" representing the following:

To add an correction entry

1. Click Add.

2. Enter the original text [Replace] and replacement text [With].

3. Click Apply.

4. Click OK.

5. Click Apply.

6. Click Close.

To modify an auto correction entry

1. Select the entry to be modified from the Auto Corrections box.

2. Click Edit.

3. Modify the text.

4. Click OK.

5. Click Apply.

6. Click Close.

To delete an auto correction entry

1. Select the entry to be modified from the Auto Corrections box.

2. Click Delete.

3. Click Apply.

4. Click Close.