
Does Adding NOINDEX Change DBCC CHECKDB with PHYSICAL_ONLY?
The NOINDEX option does change the behavior of DBCC CHECKDB (even if you’re already using PHYSICAL_ONLY). Here’s how the two options compare to one another, and how to see the difference yourself in a simple example.