Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Intelligence (Index Expert)

ClosedView Generate Indexes tab – Intelligence button options

The Intelligence page under the Generate Indexes tab on the Options window allows you to select the optimization level for generating index-set alternatives.

Intelligence Level

Option

Description

Custom

Use the Index Options page settings to determine the optimization level as needed to generate the index-set alternatives.

Predefine

Set a specific optimization intelligence level here. Values on the Index Options page adjust to this level. Levels range from 0 to 10. The higher the setting, the higher the number of Index sets generated.

Note: The General page settings can be adjusted independent of which intelligence level is chosen.

 

Related Topics

Related Documents