Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

Copy SQL with Temporary Tables to SQL Optimizer

When you copy a SQL statement from the Scanned SQL Viewer to the SQL Optimizer module, the Send to SQL Optimizer function automates this process for you. It copies the SQL statement, opens the SQL Optimizer window and inserts the SQL statement in the SQL Editor pane. When the SQL statement you are copying also includes a temporary table, the Send to SQL Optimizer function also copies the SQL statements for creating and populating the temporary table to the User-Defined Temp Table module.

Two items need to be considered when the SQL statements are automatically copied in the User-Defined Temp Table module. Is there SQL text already in the module? And does the temporary table already exist with the same or different data?

If SQL text is already entered into the User-Defined Temp Table module, you are prompted to save the current SQL to an ASCII file before it is overlaid with the new text. Saving the text enables you to use it again.

If a table with the same name already exists and you would like to recreate it with either a new definition or different data, then you must drop the table before executing the new SQL text. You can drop temporary table from the Temp Table List tab in the User-Defined Temp Table module.

 

Related Topics

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

Editor Functions

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

 

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.

Button or Menu

Function

 

Syntax Highlight

 

Auto Correction

 

Pairing Brackets

 

Argument Lookup

 

Member Lookup

Edit Menu

image\B_Indent.gif

 

Indent

Edit Menu

image\B_Outdent.gif

Outdent

Edit Menu

image\B_Comment.gif

Comment

Edit Menu

image\B_Uncomment.gif

Uncomment

Edit Menu

image\B_Uppercase.gif

Uppercase

Edit Menu

image\B_Lowercase.gif

Lowercase

 

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation