Welcome
About SQL Optimizer
About Product Improvement Program
Connections
Connect to the Database
SQL Optimization Workflow
Create Support Bundles
Join the SQL Optimizer Community
Product Licensing
Additional Resources
SQL Operations
Optimize SQL
BTBSCAN
CORSUB
DELCUR
DELETE
DFETCH
DIXSCAN
EXCEPT
EXCEPTA
FETCH
FFETCH
FIXSCAN
HBJOIN
HSSCAN
INLIST
INSERT
INTERSECT
INTERSECTA
IXAND
IXOR
IXSCAN
MERGE
MERGESTMT
MIXSCAN
MSJOIN
NLJOIN
PARTITION
PIXSCAN
PRUNED
QB
RETURN
REPARTITION
RGLIST
RIDFETCH
SELUPD
SEMIJOIN
SIXSCAN
SORT
SORTRID
STARJOIN
TBSCAN
TRUNCATE
UNION
UNIONA
UPDATE
UPDCUR
WFSCAN
WORKFILE
XIXAND
XIXOR
XIXSCAN
About Optimizing SQL
Create Optimize SQL Sessions
Open Optimizer SQL Sessions
Optimize SQL Statements
Specify Session Test Run Criteria
Automatically Optimize SQL Statements
Execution Plan
Options
Tutorial
About us
Third-party contributions
Copyright
About Execution Plans
Review Execution Plans
Get Execution Plans
Fill Missing Execution Plans
Copy Execution Plans
Generate Execution Plan Alternatives
Compare Execution Plan Alternatives
Execute Execution Plan Alternatives
Retrieve Run Results
Deploy Plan Guides
Animate Execution Plans
Generate Index Alternatives
About Generating Index Alternatives
Test Run Index Alternatives
Generate Index Alternatives
Delete Remaining Indexes
Test Run SQL Alternatives
Retrieve Run Results
Create User Defined Alternatives
Set Bind Variables
Review Alternatives
Alternative SQL Text
View Optimization Details
View Schema Information
View Bind Variables
Show or Hide Table Attributes
Show or Hide Column Attributes
Compare SQL Statements
Generate Optimize SQL Resolution Report
Troubleshoot Optimization Results
Index Setting Options
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.To set index settings
-
Click
.
- Select Optimize SQL | Index Generation | Index Settings.
-
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.