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