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.

RDB$INDEX_SEGMENTS

Column name	Data type	Length	Description
RDB$INDEX_NAME	CHAR	67	The index associated with this index segment; if the value of this column changes, the RDB$INDEX_NAME column in RDB$INDICES must also be changed
RDB$FIELD_NAME	CHAR	67	The index segment being defined; the value of this column must match the value of the RDB$FIELD_NAME column in RDB$RELATION_FIELDS
RDB$FIELD_POSITION	SMALLINT		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