> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-index_statistics-table.md).

# Information Schema INDEX\_STATISTICS Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `INDEX_STATISTICS` table shows statistics on index usage and makes it possible to do such things as locating unused indexes and generating the commands to remove them.

This is part of the [User Statistics](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/user-statistics.md) feature, which is not enabled by default.

It contains the following columns:

| Field         | Type         | Notes                                                                                                                                                                                                   |
| ------------- | ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| TABLE\_SCHEMA | VARCHAR(192) | The schema (database) name.                                                                                                                                                                             |
| TABLE\_NAME   | VARCHAR(192) | The table name.                                                                                                                                                                                         |
| INDEX\_NAME   | VARCHAR(192) | The index name (as visible in [SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md)).                                                      |
| ROWS\_READ    | BIGINT(21)   | The number of rows read from this index.                                                                                                                                                                |
| QUERIES       | BIGINT(21)   | Incremented for each index the query is part of. This assists one to see how effective the index is. From [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md) |

## Example

```sql
SELECT * FROM information_schema.INDEX_STATISTICS 
WHERE TABLE_NAME = "author";
+--------------+------------+------------+-----------+
| TABLE_SCHEMA | TABLE_NAME | INDEX_NAME | ROWS_READ |
+--------------+------------+------------+-----------+
| books        | author     | by_name    |        15 |
+--------------+------------+------------+-----------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}