지금 지원 담당자와 채팅
지원 담당자와 채팅

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

Index Options

To set index options

  1. Click .

  2. Select Optimize SQL | Index Generation | Options.
  3. Review the following for additional information:

    Option Description

    Retrieve index selectivity by sampling a maximum number of records:

    Enter the maximum number of records to retrieve for selectivity sampling.

    Maximum number of columns in a composite index:

    Enter the maximum number of columns in a composite index.

    Range: 1 to 99

    Maximum number of indexes in an index set:

    Enter the maximum number of indexes in an index set.

    Range: 1 to 99

    Evaluate columns in SELECT list:

    Select to evaluate creating an index on columns in the SELECT list.
    Quota Description

    Index Generation Quota:

    Enter the maximum number of indexes to generate.

    Range: 10 to 9999

    Index Set Generation Quota:

    Enter the maximum number of index sets to generate by combining two or more indexes.

    Range: 1 to 99,999

    Index Prefix Description

    Default prefix of index name:

    Enter the prefix placed on the index name when SQL Optimizer generates index candidates.

    Default: SQLOPT_IDX

 

Related Topics

Intelligence Options (Index Generation)

Intelligence Options (Index Generation)

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set intelligence options

  1. Click .

  2. Select Optimize SQL | Index Generation | Intelligence.
  3. Select whether to use custom or predefined intelligence levels. If you select predefined, the levels range as follows:

 

Related Topics

Index Setting Options

Test Run

Test Run Options

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set test run settings options

  1. Click .
  2. Select Optimize SQL | Test Run | Test Run Settings

  3. Review the following for additional information:

    Test Run Settings

    Description

    Custom

    Enables you to customize the settings.

    Predefined

    Uses the predefined set of options.

 

Related Topics

Execution Method Options

Order and Termination Options

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택