Chat now with support
Chat with Support

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

Intelligence Options (Index Generation)

This topic may not include a description for every field in the screen or dialog.

To set intelligence options

  1. Click in the main menu.

  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:

    ClosedIntelligence Level 1
    ClosedIntelligence Level 2
    ClosedIntelligence Level 3
    ClosedIntelligence Level 4
    ClosedIntelligence Level 5

 

Related Topics

Index Options

Index Setting Options

Index Options

To set index options

  1. Click in the main menu.

  2. Select Optimize SQL | Index Generation | Options.

  3. Review the following for additional information:

    Option Description

    Top percentage rows from table:

    Enter the percentage of the table to use for the selectivity sampling.

    Range: 1 to 100

    Minimum number of rows:

    Enter the minimum number of rows to retrieve for selectivity sampling. If this number is higher than the calculation from the Top percentage rows from table field, SQL Optimizer retrieves this number of rows from the table.

    Range: 1 to 999,999

    Maximum number of rows:

    Enter the maximum number of rows to retrieve for selectivity sampling. If this number is lower than the calculation from the Top percentage rows from table field, SQL Optimizer retrieves this number of rows from the table.

    Range: 1 to 999,999

    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: QUEST_SX_IDX

 

Related Topics

Index Setting Options

Intelligence Options (Index Generation)

Index Setting Options

This topic may not include a description for every field in the screen or dialog.

To set index settings

  1. Click in the main menu.

  2. Select Optimize SQL | Index Generation | Index Settings.

  3. Review the following for additional information:

    Total number of rows sampled for statistics calculations (%) Enter the percentage of rows to retrieve from a table to sample when calculating the selectivity of data for generating index alternatives.

 

Related Topics

Index Options

Intelligence Options (Index Generation)

Plan Control

To set intelligence options

  1. Click .

  2. Select Optimize SQL | Plan Control | Intelligence.

  3. Review the following for additional information:

    Intelligence

    Select one of the following:

    • Predefined Settings—Select an intelligence level.
    • Use Extended Total Quota—Enter a value in the Total Quota field to indicate the maximum number of execution plan alternatives generated.

    Total Quota

    Notes:

    • A higher quota generates more plans to be evaluated.
    • Total quota is not equal to the number of plans evaluated.

  

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating