Summary

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

Details

Page properties

Content

...	...	@@ -30,8 +30,6 @@
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		-
35	35	SELECT
36	36	schema_name(objects.schema_id) schema_name,
37	37	objects.name AS Table_name,
...	...	@@ -46,7 +46,7 @@
46	46	WHERE
47	47	indexes.is_primary_key = 0 --This line excludes primary key constarint
48	48	AND
49		- indexes.is_unique = 0 --This line excludes unique key constarint
	47	+ indexes. is_unique = 0 --This line excludes unique key constarint
50	50	AND
51	51	dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
52	52	AND