declare @dbid int select @dbid = db_id() select objectname=object_name(s.object_id), s.object_id, indexname=i.name, i.index_id , user_seeks, user_scans, user_lookups, user_updates from sys.dm_db_index_usage_stats s join sys.indexes i on i.object_id = s.object_id and i.index_id = s.index_id where database_id = @dbid and objectproperty(s.object_id,'IsUserTable') = 1 order by (user_seeks + user_scans + user_lookups + user_updates) asc
