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.: h ttp://msdn.microsoft.com/en-us/library/ms174338.aspx
asked Nov 11 '10 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.