# MV\_FULLTEXT\_INDEXES

This view contains segment-level information about full-text indexes for all tables and all databases in the cluster.

| Column Name     | Description                                                                                                                              |
| --------------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| `DATABASE_NAME` | The name of the database.                                                                                                                |
| `TABLE_NAME`    | The name of the table.                                                                                                                   |
| `SEGMENT_ID`    | The ID of the segment on which the index was built.                                                                                      |
| `NODE_ID`       | The ID of the node on which the index is stored.                                                                                         |
| `PARTITION`     | The ID of the partition on which the index is stored.                                                                                    |
| `BROKEN`        | Indicates if the index is broken. A value of`1`indicates the index is broken, a value of`0`indicates the index was created successfully. |

***

Modified at: December 22, 2025

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fulltext-indexes/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fulltext-indexes/)

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