Changes for page index-maintenance

Last modified by Gideon Lombard on 2023/05/22 23:50
<
From version < 4.1 >
edited by Rudi Marais
on 2022/02/10 15:33
To version < 3.1 >
edited by Rudi Marais
on 2022/02/10 15:31
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -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
47 + 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

Applications

Navigation

Need help?

If you need help with XWiki you can contact: