Installation
Installation Requirements
Install or Upgrade SQL Optimizer
Silent Install of SQL Optimizer
Uninstall SQL Optimizer
Register SQL Optimizer
Configuration
Troubleshoot SQL Optimizer
"Failed to Connect to IBM DB2 LUW"
No Index Recommendations from IBM DB2 LUW
"Failed to initialize the application"
Copyright
Intelligence (Optimization Tab)
The Intelligence page under the SQL Rewrite tab on the Options window allows users to select the optimization level for rewriting the SQL. You can customize the optimization level or select a predefined level.
Intelligence Level
|
Option |
Description |
|---|---|
|
Custom |
Enables you to customize the settings on the SQL Options, SQL Rewrite (1), SQL Rewrite (2), and Quota pages. |
|
Predefine |
Uses the predefined optimization level. The SQL Options, SQL Rewrite (1), and Quota pages are automatically updated according to the level selected. The higher the level, the more likely SQL Rewrite finds a better SQL alternative. Note: The settings on the SQL Rewrite(2) and the General pages are adjusted independent of the optimization-level settings. |