Index Options
To set index options
-
Click
.
- Select Optimize SQL | Index Generation | Options.
-
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
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
-
Click
- Select Optimize SQL | Index Generation | Intelligence.
-
Select whether to use custom or predefined intelligence levels. If you select predefined, the levels range as follows:
Index Option
Option Section
Top percentage rows from table = 5
Minimum number of rows = 300
Maximum number of rows = 600
Maximum number of columns in a composite index = 2
Maximum number of indexes to generate per alternative = 2
Quota Section
Index Generation Quota = 20
Index Set Generation Quota = 30
Index Option
Option Section
Top percentage rows from table = 10
Minimum number of rows = 500
Maximum number of rows = 1000
Maximum number of columns in a composite index = 4
Maximum number of indexes to generate per alternative = 4
Quota Section
Index Generation Quota = 50
Index Set Generation Quota = 100
Index Option
Option Section
Top percentage rows from table = 15
Minimum number of rows = 800
Maximum number of rows = 1600
Maximum number of columns in a composite index = 5
Maximum number of indexes to generate per alternative = 5
Quota Section
Index Generation Quota = 80
Index Set Generation Quota = 160
Index Option
Option Section
Top percentage rows from table = 20
Minimum number of rows = 1500
Maximum number of rows = 3000
Maximum number of columns in a composite index = 6
Maximum number of indexes to generate per alternative = 6
Quota Section
Index Generation Quota = 200
Index Set Generation Quota = 400
Index Option
Option Section
Top percentage rows from table = 25
Minimum number of rows = 4000
Maximum number of rows = 8000
Maximum number of columns in a composite index = 8
Maximum number of indexes to generate per alternative = 8
Quota Section
Index Generation Quota = 500
Index Set Generation Quota = 1000
Intelligence Level 1
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
- Click
-
Select Optimize SQL | Test Run | Test Run Settings
-
Review the following for additional information:
Test Run Settings
Description
Custom
Enables you to customize the settings.
Predefined
Uses the predefined set of options.