sys.dm_db_xtp_index_stats (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Contains statistics collected since the last database restart.
For more information, see In-Memory OLTP (In-Memory Optimization) and Guidelines for Using Indexes on Memory-Optimized Tables.
| Column name | Data type | Description |
|---|---|---|
| object_id | bigint | ID of the object to which this index belongs. |
| xtp_object_id | bigint | Internal ID corresponding to the current version of the object. Note: Applies to SQL Server 2016 (13.x). |
| index_id | bigint | ID of the index. The index_id is unique only within the object. |
| scans_started | bigint | Number of In-Memory OLTP index scans performed. Every select, insert, update, or delete requires an index scan. |
| scans_retries | bigint | Number of index scans that needed to be retried, |
| rows_returned | bigint | Cumulative number of rows returned since the table was created or the start of SQL Server. |
| rows_touched | bigint | Cumulative number of rows accessed since the table was created or the start of SQL Server. |
| rows_expiring | bigint | Internal use only. |
| rows_expired | bigint | Internal use only. |
| rows_expired_removed | bigint | Internal use only. |
| phantom_scans_started | bigint | Internal use only. |
| phantom_scans_retries | bigint | Internal use only. |
| phantom_rows_touched | bigint | Internal use only. |
| phantom_expiring_rows_encountered | bigint | Internal use only. |
| phantom_expired_rows_encountered | bigint | Internal use only. |
| phantom_expired_removed_rows_encountered | bigint | Internal use only. |
| phantom_expired_rows_removed | bigint | Internal use only. |
| object_address | varbinary(8) | Internal use only. |
Permissions
Requires VIEW DATABASE STATE permission on the current database.
Permissions for SQL Server 2022 and later
Requires VIEW DATABASE PERFORMANCE STATE permission on the database.