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.
phatom_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.


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.

See also

Next steps