Does DBCC CheckDB update the sysindexes table, similar to DBCC Updateusage?
Thanks,
MitchSince DBCC CHECKDB by itself does not acquire a table lock, it suggests the
system tables are not necessarily updated. This is the same case with DBCC
CHECKTABLE we well.
Hoewever, if you use the REPAIR options associated with DBCC CHECKDB, it
will update the sysindexes table since it can include allocation and
deallocation of rows and pages for correcting allocation errors, structural
row or page errors, and deletion of corrupted text objects.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment