To set index options
Click .
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)
To set intelligence options
Click .
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
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
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center