Index Usage Statistics of the current database.

IndexStats.sql

select OBJECT_NAME(iu.object_id) as table_name
     , i.name
     , iu.user_seeks
     , iu.user_scans
     , iu.user_lookups
     , iu.user_updates
     , iu.last_user_seek
     , iu.last_user_scan
     , iu.last_user_lookup
     , iu.last_user_update
     , i.type_desc
  from sys.dm_db_index_usage_stats iu
  join sys.indexes i
    on iu.object_id = i.object_id 
   and iu.index_id = i.index_id
 where database_id = DB_ID()