quote:

---

Statistic Description
Pages Scanned
Number of pages in the table or index.

Extents Scanned
Number of extents in the table or index.

Extent Switches
Number of times the DBCC statement moved from one extent to another while the statement traversed the pages of the table or index.

Avg. Pages per Extent
Number of pages per extent in the page chain.

Scan Density [Best Count: Actual Count]
Is a percentage. It is the ratio Best Count to Actual Count. This value is 100 if everything is contiguous; if this value is less than 100, some fragmentation exists.

Best Count is the ideal number of extent changes if everything is contiguously linked. Actual Count is the actual number of extent changes.

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. An out-of-order page is one for which the next page indicated in an IAM is a page different from the page pointed to by the next page pointer in the leaf page.

Extent Scan Fragmentation
Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps. An out-of-order extent is one for which the extent that contains the current page for an index is not physically the next extent after the extent that contains the previous page for an index.

Note:
This number is meaningless when the index spans multiple files.



Avg. Bytes Free per Page
Average number of free bytes on the pages scanned. The larger the number, the less full the pages are. Lower numbers are better if the index will not have many random inserts. This number is also affected by row size; a large row size can cause a larger number.

Avg. Page density (full)
Average page density, as a percentage. This value takes into account row size. Therefore, the value is a more accurate indication of how full your pages are. The larger the percentage, the better.

---