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 | USERSPACE1 | 8192 | 32 | -1 | IBMDEFAULTGROUP | |
---|---|---|---|---|---|---|---|---|---|---|
Table Name | CARDF | NPAGESF | ||||||||
SARAVIND.EMPLOYEE | 42 | 1 | ||||||||
Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF | ||
SARAVIND.PK_EMPLOYEE | -1.0 | P | 1 | 1 | 100.0 | EMPNO | 42 | 42 | ||
SARAVIND.XEMP2 | -1.0 | D | 1 | 1 | 100.0 | WORKDEPT | 8 | 8 | ||
Column Group | MCARDF | |||||||||
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | USERSPACE1 | 8192 | 32 | -1 | IBMDEFAULTGROUP | |
Table Name | CARDF | NPAGESF | ||||||||
SARAVIND.DEPARTMENT | 14 | 1 | ||||||||
Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF | ||
DB2ADMIN.IDX904022138360000 | -1.0 | D | -1 | -1 | -1.0 | LOCATION | 1 | -1 | ||
DEPTNO | 14 | -1 | ||||||||
SARAVIND.PK_DEPARTMENT | -1.0 | P | 1 | 1 | 100.0 | DEPTNO | 14 | 14 | ||
SARAVIND.XDEPT2 | -1.0 | D | 1 | 1 | 100.0 | MGRNO | 9 | 9 | ||
SARAVIND.XDEPT3 | -1.0 | D | 1 | 1 | 100.0 | ADMRDEPT | 3 | 3 | ||
Column Group | MCARDF | |||||||||
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | USERSPACE1 | 8192 | 32 | -1 | IBMDEFAULTGROUP | |
Table Name | CARDF | NPAGESF | ||||||||
SARAVIND.PROJECT | 20 | 1 | ||||||||
Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF | ||
DB2ADMIN.IDX904022138410000 | -1.0 | D | -1 | -1 | -1.0 | DEPTNO | 8 | -1 | ||
RESPEMP | 17 | -1 | ||||||||
PROJNAME | 20 | -1 | ||||||||
PROJNO | 20 | -1 | ||||||||
MAJPROJ | 8 | -1 | ||||||||
SARAVIND.PK_PROJECT | -1.0 | P | 1 | 1 | 100.0 | PROJNO | 20 | 20 | ||
SARAVIND.XPROJ2 | -1.0 | D | 1 | 1 | 100.0 | RESPEMP | 17 | 17 | ||
Column Group | MCARDF | |||||||||
Table Space | Page Size | Extent Size | Prefetch Size | Partition Group | SYSCATSPACE | 8192 | 4 | -1 | IBMCATGROUP | |
Table Name | CARDF | NPAGESF | ||||||||
SARAVIND.DEPT | -1 | -1 | ||||||||
Index Name | Cluster Factor | Unique Rule | NLEAF | NLEVEL | Cluster Ratio | Key Column Name | COLCARDF | MCARDF | ||
Column Group | MCARDF | |||||||||