Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set execution plan options
.
Select General | Execution Plan.
Review the following for additional information:
| Execution Plan | Description |
|
TABLE ACCESS FULL warning threshold |
Specify a table size threshold at which the TABLE ACCESS FULL operation is highlighted in red. |
|
Abbreviate JOIN text |
Shorten JOIN text. |
|
Color |
Specify the color of the individual items in the query plan by clicking the Color column in the row for the item and selecting the new color from the dialog. |
|
Font |
Specify the font settings of the individual items in the query plan by clicking the Font column in the row for the item and selecting the new settings from the dialog. |
|
Note: The execution plan displays in several panes. The color and font settings in this window controls the settings in all the Execution Plan panes. Right-click the execution plan and select Plan Options to customize display options for individual panes. | |
Note: These options apply to SQL Optimizer..
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set directory setup options
.
Review the following for additional information:
|
Directory for |
Description |
Default Directory |
| Optimize SQL data directory | Optimize SQL files | C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer for DB2 z/OS\version\Optimize SQL Data |
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set appearance options
.
Select General | Appearance.
Review the following for additional information:
| Font Settings | Description |
|
SQL Text Editor |
Select the font settings for the SQL Text Editor. |
|
Other Data |
Select the font settings for other data. |
|
Size |
Select the font size. |
To change an Options setting
| » | Click to specify the desired settings. |
When you change the settings, your latest settings are always saved and restored each time to exit and restart the program. You can also save several sets of option settings either by saving settings from one or more tabs or by saving all the option settings.
To save specific settings so that you can use them later
In the Options window, click Save.
Enter a filename for the saved settings. Click Save.
From the Save Options Profile window, select the tabs for the settings you want to save. Click OK.
To restore the saved settings
In the Options window, click Load.
In the Open File window, select the filename. Click Open.
From the Save Options Profile window, select the tabs for the settings you want to load.
