RDB$INDEX SEGMENTS
Go Up to System Tables
RDB$INDEX_SEGMENTS
specifies the columns that comprise an index for a table. Modifying these rows corrupts rather than changes an index unless the RDB$INDICES
row is deleted and re-created in the same transaction.
Column name | Data type | Length | Description |
---|---|---|---|
|
|
67 |
The index associated with this index segment; if the value of this column changes, the |
|
|
67 |
The index segment being defined; the value of this column must match the value of the |
|
|
Position of the index segment being defined; corresponds to the sort order of the index | |
RDB$STATISTICS |
DOUBLE PRECISION |
OSD 16 - Segment-specific statistics for index selectivity |