Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.2 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating