Need tsql to find index usage on views

Question

I have some views that have indexes and i want to get their usage - seeks, scan, lookups - but i cannot find the tsql code.

Answer 1

SELECT v.name, i.name, ius.*
FROM  sys.dm_db_index_usage_stats ius
JOIN   sys.views v ON ius.object_id = v.object_id
JOIN  sys.indexes i ON ius.object_id = i.object_id
                   AND ius.index_id = i.index_id
WHERE  ius.database_id = db_id()