Hi,

I've run dbcc showcontig with tableresults, all_indexes and it reports a logical fragmentation of 100% for one of my tables but when i run dbcc showcontig (certificate) with all_indexes I get 0% logical fragmentation. As shown below :

DBCC SHOWCONTIG scanning 'Certificate' table...
Table: 'Certificate' (1333579789); index ID: 1, database ID: 6
TABLE level scan performed.
- Pages Scanned................................: 1
- Extents Scanned..............................: 1
- Extent Switches..............................: 0
- Avg. Pages per Extent........................: 1.0
- Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.00%
- Avg. Bytes Free per Page.....................: 1088.0
- Avg. Page Density (full).....................: 86.56%

As the table (clustered) is all on one page, zero must be the right answer, so does the fact the "with tableresults" option reports 100% logical scan fragmentation mean that there's a bug in the "with tableresults" option?