VMS Help  —  SQL72  System Tables, RDB$INDICES  RDB$FLAGS
    Represents flags for RDB$INDICES system table.

    Bit
    Position   Description

    0          Hashed index.
    1          Index segments are numeric with mapping values
               compression.
    2          Hashed ordered index. (If bit is clear, hashed
               scattered.)
    3          Reserved for future use.
    4          Run-length compression.
    5          Index is disabled or enabled deferred.
    6          Build pending (enabled deferred).
    7          Reserved for future use.
    8          Reserved for future use.
    9          Reserved for future use.
    10         Reserved for future use.
    11         If on, duplicates are compressed.
    12         Sorted ranked index.
    13         Prefix cardinalities disabled.
    14         Use the full collection algorithm for prefix
               cardinality.
    15         Index generated for a constraint when SET FLAGS 'AUTO_
               INDEX' was enabled.
Close Help