Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    71

    Unanswered: dbcc showcontig with tablersults

    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?

    Clive

  2. #2
    Join Date
    Nov 2002
    Posts
    71

    Talking

    I found it. I was using the 'WITH FAST' parameter. Without FAST, it returns the row count.

    Clive

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •