Tag Archives: Identify unused index

How to identify unused indexes in SQL Server

We can use dynamic management view “sys.dm_db_index_usage_stats” to identify unused indexes on SQL Server. DMV – sys.dm_db_index_usage_stats This DMV shows you how many times the index was used for user queries. SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],        I.[NAME] AS [INDEX … Continue reading

Posted in Advanced SQL | Tagged , , | Leave a comment