Changes for page index-maintenance
Last modified by Gideon Lombard on 2023/05/22 23:50
Change comment:
There is no comment for this version
Summary
-
Page properties (3 modified, 0 added, 0 removed)
-
Objects (0 modified, 0 added, 1 removed)
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 - xwiki:Technical Documentation.analysis.sql.sql-performance.WebHome1 +Technical Documentation.analysis.sql-performance.WebHome - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. gideonl1 +XWiki.rudim - 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
- XWiki.XWikiComments[0]
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.gideonl - Comment
-
... ... @@ -1,1 +1,0 @@ 1 -{{mention reference="XWiki.rudim" style="FULL_NAME" anchor="XWiki-rudim-z3bw3b"/}} should these not be on the DBG schema? - Date
-
... ... @@ -1,1 +1,0 @@ 1 -2022-12-03 05:28:56.355