Table-level derived statistics

The “Derived statistics” in the table-level section reports the statistics derived from the “Data Page CR count” and data page count. Table 37-3 describes the output.

Table 37-3: Cluster ratio for a table

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.