FTB NON UNIQUE INDEX field (FTB_NON_UNIQUE_INDEX subsystem parameter)
The FTB_NON_UNIQUE_INDEX subsystem parameter specifies whether fast index traversal (FTB) is enabled for non-unique indexes.
FL 508
Acceptable values: | NO, YES |
---|---|
Default: | NO |
Data sharing scope: | It is recommended that all members use the same setting |
Online changeable: | Yes |
Update: | Option 15 on panel DSNTIPB |
DSNZPxxx: | DSN6SPRM.FTB_NON_UNIQUE_INDEX |
- YES
- Fast index traversal for non-unique indexes is enabled.
- NO
- Fast index traversal for non-unique indexes is disabled. This is the default setting.