Hi,

When I runn DBCC SHOWCONTIG on a table with no indexes, I get

DBCC SHOWCONTIG scanning 'AssocLocation' table...
Table: 'AssocLocation' (226815870); index ID: 0, database ID: 17
TABLE level scan performed.
- Pages Scanned................................: 5
- Extents Scanned..............................: 3
- Extent Switches..............................: 2
- Avg. Pages per Extent........................: 1.7
- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]
- Extent Scan Fragmentation ...................: 66.67%
- Avg. Bytes Free per Page.....................: 3128.6
- Avg. Page Density (full).....................: 61.35%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Should I be worried that the scan density is only 33%? And how do I correct that if there is no index?

Also, when I run DBCC SHOWCONTIG on a table that has indexes - sometimes after running DBCC DBREINDEX or DBCC INDEXDEFRAG the scan density doesn't change. Does anyone understand why in some cases those two statements don't seem to change anything? It is my understanding that scan density should be near 100% and extent scan fragmentation should be close to 0 - is that thinking correct?

Thanks everyone!

Luanne

MS Sql Server LazyDBA home page