Changes for page index-maintenance

Last modified by Gideon Lombard on 2023/05/22 23:50
<
From version < 3.1 >
edited by Rudi Marais
on 2022/02/10 15:31
To version < 6.3 >
edited by Gideon Lombard
on 2023/05/18 05:52
>
Change comment: Updated parent field.

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Technical Documentation.analysis.sql-performance.WebHome
1 +xwiki:Technical Documentation.analysis.sql.sql-performance.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.rudim
1 +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,
... ... @@ -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
49 + 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
XWiki.XWikiComments[0]
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?
Date
... ... @@ -1,0 +1,1 @@
1 +2022-12-03 05:28:56.355

Applications

Navigation

Need help?

If you need help with XWiki you can contact: