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 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.
Data type and value of variables are entered using the Parameters window. If variables are embedded in the original SQL statement, the Parameters window will be displayed each time you launch the Run Result, Run for First Record, Run for All Records, and Batch Run functions. The values entered in the Parameters window have a direct result on the run time and run result retrieved.
The parameter values that you have previously entered can be saved by selecting the Enable SQL parameter history Options setting. If the same parameter is used in a SQL statement again, the value and the data type from the last time it was used is automatically entered for you.
To help identify the data type and value
Click Browse to expand the Parameters window. The bottom pane appears displaying object and data information corresponding to the selected objects from the SQL statement. Select the object to browsed using the Objects and Columns lists. If a column is selected (asterisk * selects all columns from the selected object), the corresponding data type is shown.
Click Load Data and highlight the cell with the variable value from the data grid. Then click Use Data & Data type or double-click the cell to copy the compatible data type and value to the parameter selected at the top of the window.
Click Use Data type to copy a compatible data type to the parameter selected at the top of the window.
After the data type and value of all the parameters have been selected, click OK.
Note: If the Parameters window appears when you do not have variables in the SQL statement, this may be caused by incorrect spelling of column or table names, pointing to the wrong schema, or the tables or columns do not exist in the database. If the tables or columns have been created since you opened SQL Optimizer, you may need to Synchronize the Data Dictionary.
When you are selecting database objects from the list of all objects, you can filter the list in order to more quickly locate specify objects.
To filter database objects
Click 
In the Schema box, select the schema name where the objects reside.
In the Object type box, select the database object type.
In the Filter box, enter the filtering criteria using the % wildcard to replaces multiple characters. The filter is case sensitive, so you must match the upper or lowercase characters of the database object name.
If you would like to exclude the database objects that meet the filter criteria instead of including them, check the Exclude filter box.
Select the database objects from the list.
