Статистика використання індексів по певній таблиці

GO 

SELECT OBJECT_SCHEMA_NAME(i.object_id) AS SchemaName, OBJECT_NAME(i.object_id) AS TableName, i.name AS IndexName, i.index_id, i.type_desc AS IndexType, us.user_seeks, us.user_scans, us.user_lookups, us.user_updates, us.last_user_seek, us.last_user_scan, us.last_user_lookup, us.last_user_update 

FROM sys.indexes i JOIN sys.dm_db_index_usage_stats us ON i.object_id = us.object_id AND i.index_id = us.index_id 

WHERE OBJECTPROPERTY(i.object_id, 'IsUserTable') = 1 AND us.database_id = DB_ID('Base2Base.Tcu5Db40727_New') AND (us.user_seeks > 0 OR us.user_scans > 0 OR us.user_lookups > 0) and OBJECT_NAME(i.object_id)='InventoryJournalRecords' 

ORDER BY (us.user_seeks + us.user_scans + us.user_lookups) DESC;