SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Installation Requirements Install or Upgrade SQL Optimizer Silent Install of SQL Optimizer Uninstall SQL Optimizer Register SQL Optimizer

Configuration

Access SQL Optimizer Configure SQL Optimizer

Troubleshoot SQL Optimizer

"Failed to Connect to IBM DB2 LUW" No Index Recommendations from IBM DB2 LUW "Failed to initialize the application"

Index Options (Index Expert)

Closed View 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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Index Options (Index Expert)

Options

Quota