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. |
---|
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | | TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.HOUSEHOLD_DEMOGRAPHICS | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183257750 | -1.0 | P | -1 | -1 | -1.0 | HD_DEMO_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.CUSTOMER | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183257350 | -1.0 | P | -1 | -1 | -1.0 | C_CUSTOMER_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.STORE_SALES | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183259140 | -1.0 | P | -1 | -1 | -1.0 | SS_ITEM_SK | -1 | -1 |
| | | | | | | | SS_TICKET_NUMBER | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.CUSTOMER_DEMOGRAPHICS | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183255770 | -1.0 | P | -1 | -1 | -1.0 | CD_DEMO_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.STORE | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183257020 | -1.0 | P | -1 | -1 | -1.0 | S_STORE_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.PROMOTION | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183258030 | -1.0 | P | -1 | -1 | -1.0 | P_PROMO_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.ITEM | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183256810 | -1.0 | P | -1 | -1 | -1.0 | I_ITEM_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.CUSTOMER_ADDRESS | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183255500 | -1.0 | P | -1 | -1 | -1.0 | CA_ADDRESS_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.TIME_DIM | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183256440 | -1.0 | P | -1 | -1 | -1.0 | T_TIME_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | | | | | | |
---|
TS00001 | 4096 | 32 | 128 | IBMDEFAULTGROUP | | | | | | | | | Table Name | CARDF | NPAGESF | | | | | | |
---|
| | DB2ADMIN.DATE_DIM | -1 | -1 | | | | | | |
| | Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF |
---|
| | DB2ADMIN.SQL090403183255920 | -1.0 | P | -1 | -1 | -1.0 | D_DATE_SK | -1 | -1 |
| | Column Group | MCARDF | | | | | | | |
---|
| | | | | | | | | | |