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

SQL Navigation

Several ways are provided to navigate through the SQL statements displayed in multiple tab sets.

  • Click the tab set at the bottom of the window.

  • Use the Navigate | Go to SQL function which navigates to a specify SQL number.

  • Use the navigation buttons on the toolbar or corresponding menu items.

Button

Menu Item

Description

image\B_FirstSQL.gif

Navigate | First SQL

Display the first SQL statement.

image\B_PreviousSQL.gif

Navigate | Previous SQL 

Display the previous SQL statement.

image\B_NextSQL.gif

Navigate | Next SQL 

Display the next SQL statement. 

image\B_LastSQL.gif

Navigate | Last SQL

Display the last SQL statement.

 

Find a SQL Using a Text String

The Find SQL function is available in the SQL Optimizer and Scanner SQL Viewer window. It searches through SQL statements until it finds the first occurrence of the text string you specify. In SQL Optimizer, Find SQL searches the SQL syntax currently displayed in the SQL Text pane. In SQL Scanner, the function searches across all SQL statements displayed on the SQL tabs.

To find specific text within the SQL statements

  1. Select SQL | Find SQL.

  2. Enter the text string to be found and click Find.

  3. To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].

 

Comments

Due to the lack of uniform standards in the presentation of comments within source code, it is almost impossible to implement each and every commenting indicator. We have therefore chosen to support the three most popular delimiters:

Comment Syntax

Comment

--

single line

//

single line

starting with /*

ending with */

block

During optimization these comments will be removed and will not be shown in the list of optimized SQL statements.

SQL Optimizerdoes not accept any other comment delimiters.

 

Variables

Variables can be embedded in the original SQL statement without pre-defining the data type and value. All variable names will be highlighted in red after the optimization process. SQL Optimizer will recognize declaration of variables either with or without a ":" (host variables) or "?" (parameter markers) sign. During optimization, run time or run result, the data type and value of the variables will require definition by using the Parameters window.

 

Related Documents