# MV\_FULLTEXT\_INDEX\_STATUS

This view contains partition-level information about the status of 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.                                                                           |
| `PARTITION`        | The ID of the partition on which the index is stored.                                            |
| `NODE_ID`          | The ID of the node on which the index is stored.                                                 |
| `PROGRESS_PERCENT` | The percentage of rows in the table's columnstore segments that have been indexed.               |
| `BROKEN_PERCENT`   | The percentage of rows in the table's columnstore segments that have an associated broken index. |

***

Modified at: February 11, 2026

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

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