DBCC SHOWCONTIG WITH TABLERESULTS will show a ROW column for an index's row count. However, on an important table with quite a few indexes that I am using as a baseline, ROW is NULL for all indexes. Why? BOL definines ROWS as:-
"Number of data or index records at that level of the index. For a heap, this is the number of data records in the entire heap."
By the way, if I select from sysindexes for a one of the above indexes, there is a correct rowcount for the index.
Any ideas?
CliveI found it. I was using the 'WITH FAST' parameter. Without FAST, it returns the row count.
Clive
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment