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