Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.3.1 - Installation Guide

Intelligence (Optimization Tab)

ClosedView SQL Rewrite tab – Intelligence options

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




Enables you to customize the settings on the SQL Options, SQL Rewrite (1), SQL Rewrite (2), and Quota pages.


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.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating