Choose features for the access method
The Virtual-Index Interface (VII) provides many optional features. Choose the features that you need to fulfill the access-method specifications.
The following optional features support data definition:
- Data in extspaces, sbspaces, or both
- Fragmentation
- Unique indexes
- Alternative indexes on the same columns
- Multiple-column index keys
Support for the following optional features can contribute
to access-method performance:
- Clustered data
- Parallel-function execution
- More than one row returned per scan-function call
- More than one index entry inserted per insert-function call
- Key scan, which creates rows from index keys
- Complex qualifications