Chat now with support
Chat mit 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

Index Options (Index Expert)

ClosedView Index Expert tab – Options button options

The Index Options page under the Index Expert tab on the Options window defines how Index Expert generates index-set alternatives. If you selected Customize on the Intelligence page, these values determine the optimization level for index generation.

Options

Index Options

Description

Retrieve index selectivity by sampling a maximum number of records

(Default: 1000, Range = 10 to 99999)

Specify the number of records to be selected for determine the selectivity of the data.

Evaluate columns in SELECT list

Specify whether to consider SELECT list columns when generating indexes.

Maximum number of columns in a composite index

(Default 4, Range 1 to 30)

Specify the maximum number of columns in a composite index.

Maximum number of indexes in an Index Set

(Default 4, Range 1 to 99)

Specify the maximum number of indexes in an index set.

Quota

Index Generation Quotas

Description

Index Generation Quota

Specify the maximum number of indexes generated.

Index Set Generation Quota

Specify the maximum number of index sets generated.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen