Summary

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

Details

Page properties

Content

...	...	@@ -31,8 +31,7 @@
31	31	{{code language="sql"}}
32	32
33	33	SELECT
34		- schema_name(objects.schema_id) schema_name,
35		- objects.name AS Table_name,
	34	+ objects.name AS Table_name,
36	36	indexes.name AS Index_name,
37	37	dm_db_index_usage_stats.user_seeks,
38	38	dm_db_index_usage_stats.user_scans,
...	...	@@ -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
	46	+ 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