Sankar Reddy
5) It has a flag not to run against nonclustered indexes.
FROM BOL: http://msdn.microsoft.com/en-us/library/ms176064.aspx
-- Check the AdventureWorks database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks, NOINDEX);
GO
So, it is true.
Repeating myself:
From Books On Line
DBCC CHECKDB
Runs DBCC CHECKALLOC on the database.
Runs DBCC CHECKTABLE on every table and view in the database.
Runs DBCC CHECKCATALOG on the database
From DBCC CHECKALLOC.
http://technet.microsoft.com/en-us/library/aa258809(SQL.80).aspx
Note NOINDEX is maintained for backward compatibility only. All indexes are checked when executing DBCC CHECKALLOC.
From Merriam-Webster Dictionary for ALL
every member or individual component of
So then Sankar Reddy what you are saying is that DBCC CHECKDB when invoking DBCC CHECKALLOC passes to it a an undocumented parameter so that DBCC CHECKALLOC does NOT perform as it states in BOL