MV_FTS_MERGED_INDEXES

This view shows full-text indexes that span multiple JLucene segments. The view only includes merged indexes, that is indexes with more than one segment.

Column Name

Description

DATABASE_NAME

The name of the database.

TABLE_NAME

The name of the table on which this index is built.

PARTITION

The ID of the partition where this index resides.

NODE_ID

The ID of the node where this index resides.

FTS_INDEX_ID

The internal ID of the full-text index.

NUM_SEGMENTS

The number of Lucene segments in this index.

This value is always greater than 1 as this view only includes merged indexes.

SEGMENT_IDS

A JSON array of the individual Lucene segment IDs that make up this index.

NUM_ROWS

The total number of rows indexed.

FTS_INDEX_VERSION

The full-text index metadata version.

SIZE

The uncompressed size of the full-text index, in bytes.

Last modified:

Was this article helpful?