If I loop through the indexes of a table and do a
This Books Online entry kind of implies that using the index_id will also do a check on the cluster (or HEAP):
So if I do:
Have I actually just checked the clustered index 3 times?
Our environment has SQL 2000, 2005, and 2008 servers, so applies to all those versions.
asked Nov 11, 2010 at 08:55 AM in Default
That's what I believe, given the BOL text.
Makes sense if you think about it - the physical data is actually a heap or a clustered-index, so checking a particular index would by default check the data in whatever structure it is held.