Summary

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

Details

Page properties

Content

...	...	@@ -30,10 +30,8 @@
30	30
31	31	{{code language="sql"}}
32	32
33		---// https://wiki.ebsphere.africa/xwiki/bin/view/Technical%20Documentation/analysis/sql-performance/index-maintenance/#
34	34	SELECT
35		- schema_name(objects.schema_id) schema_name,
36		- objects.name AS Table_name,
	34	+ objects.name AS Table_name,
37	37	indexes.name AS Index_name,
38	38	dm_db_index_usage_stats.user_seeks,
39	39	dm_db_index_usage_stats.user_scans,
...	...	@@ -45,7 +45,7 @@
45	45	WHERE
46	46	indexes.is_primary_key = 0 --This line excludes primary key constarint
47	47	AND
48		- indexes.is_unique = 0 --This line excludes unique key constarint
	46	+ indexes. is_unique = 0 --This line excludes unique key constarint
49	49	AND
50	50	dm_db_index_usage_stats.user_updates <> 0 -- This line excludes indexes SQL Server hasn’t done any work with
51	51	AND