Home Forums SQL Server 7,2000 Administration DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question RE: DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question

  • As per books online:

    Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of an index. This number is not relevant to heaps and text indexes.

    Extent Scan Fragmentation Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps.

    You should not consider these numbers for heaps. In the sheet attached by you this can be easily depicted.

    MJ