Intelligence (Optimization Tab)
Intelligence
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. |