Legend | Name | Description |
---|
CARDF | Total number of rows in the table. |
---|
COLCARDF | Estimated number of distinct values in the column. |
---|
Cluster Factor | The data clustering factor of the index, represented as a ratio between 0 and 1. This value is -1 if the clustering factor is unavailable, or if the cluster ratio value is shown instead. |
---|
Cluster Ratio | Degree of data clustering of the index. |
---|
Column Group | Column group. |
---|
Extent Size | Number of pages of table data that will be written to a container before data will be written to the next container. |
---|
Index Name | Index name. |
---|
Key Column Name | Key column name. |
---|
MCARDF | Estimated number of distinct values for the multi-column group. |
---|
NLEAF | Number of active leaf pages in the table space. |
---|
NLEVEL | Number of levels in the index tree. |
---|
NPAGESF | Total number of pages on which rows of the table appear. |
---|
Page Size | Size of a page in the table space in kilobytes. |
---|
Partition Group | Database partition group range. |
---|
Prefetch Size | Number of pages to be read when prefetching is performed; set to -1 when automatic prefetch size is enabled. |
---|
Table Name | Table name. |
---|
Table Space | Table space name. |
---|
Unique Rule | Unique Rule. |
---|