The “Derived statistics” in the table-level section reports the statistics derived from the “Data Page CR count” and data page count. Table 6-3 describes the output.
Row label |
Information provided |
|---|---|
Data page cluster ratio |
The data page cluster ratio is used to estimate the effectiveness of large I/O. It is used to estimate the number of I/Os required to read an allpages-locked table by following the page chain, and to estimate the number of large I/Os required to scan a data-only-locked table using an OAM scan. |
Space utilization |
The ratio of the minimum space usage for this table, and the current space usage. |
Large I/O efficiency |
Estimates the number of useful pages brought in by each large I/O. |
