# 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.                                                                    |

***

Modified at: July 27, 2026

Source: [/cloud/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fts-merged-indexes/](https://docs.singlestore.com/cloud/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fts-merged-indexes/)

(An index of the documentation is available at /llms.txt)