> 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-myrocks-tables/information-schema-rocksdb_index_file_map-table.md).

# Information Schema ROCKSDB\_INDEX\_FILE\_MAP Table

The Information Schema ROCKSDB\_INDEX\_FILE\_MAP table maps MyRocks indexes to their corresponding SST files, useful for understanding data storage.

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `ROCKSDB_INDEX_FILE_MAP` table is included as part of the [MyRocks](/docs/server/server-usage/storage-engines/myrocks.md) storage engine.

The `PROCESS` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md) is required to view the table.

It contains the following columns:

| Column                 | Description |
| ---------------------- | ----------- |
| COLUMN\_FAMILY         |             |
| INDEX\_NUMBER          |             |
| SST\_NAME              |             |
| NUM\_ROWS              |             |
| DATA\_SIZE             |             |
| ENTRY\_DELETES         |             |
| ENTRY\_SINGLEDELETES   |             |
| ENTRY\_MERGES          |             |
| ENTRY\_OTHERS          |             |
| DISTINCT\_KEYS\_PREFIX |             |

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

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