Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -30,6 +30,8 @@
30	30
31	31	{{code language="sql"}}
32	32
	33	+--// https://www.sqlshack.com/how-to-identify-and-monitor-unused-indexes-in-sql-server/
	34	+
33	33	SELECT
34	34	schema_name(objects.schema_id) schema_name,
35	35	objects.name AS Table_name,
...	...	@@ -44,7 +44,7 @@
44	44	WHERE
45	45	indexes.is_primary_key = 0 --This line excludes primary key constarint
46	46	AND
47		- indexes. is_unique = 0 --This line excludes unique key constarint
	49	+ indexes.is_unique = 0 --This line excludes unique key constarint
48	48	AND
49	49	dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
50	50	AND