Table Report

Legend
NameDescription
CARDFTotal number of rows in the table.
COLCARDFEstimated number of distinct values in the column.
Cluster FactorThe 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 RatioDegree of data clustering of the index.
Column GroupColumn group.
Extent SizeNumber of pages of table data that will be written to a container before data will be written to the next container.
Index NameIndex name.
Key Column NameKey column name.
MCARDFEstimated number of distinct values for the multi-column group.
NLEAFNumber of active leaf pages in the table space.
NLEVELNumber of levels in the index tree.
NPAGESFTotal number of pages on which rows of the table appear.
Page SizeSize of a page in the table space in kilobytes.
Partition GroupDatabase partition group range.
Prefetch SizeNumber of pages to be read when prefetching is performed; set to -1 when automatic prefetch size is enabled.
Table NameTable name.
Table SpaceTable space name.
Unique RuleUnique Rule.



Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.HOUSEHOLD_DEMOGRAPHICS-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183257750-1.0P-1-1-1.0HD_DEMO_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.CUSTOMER-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183257350-1.0P-1-1-1.0C_CUSTOMER_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.CUSTOMER_DEMOGRAPHICS-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183255770-1.0P-1-1-1.0CD_DEMO_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.STORE-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183257020-1.0P-1-1-1.0S_STORE_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.ITEM-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183256810-1.0P-1-1-1.0I_ITEM_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.CUSTOMER_ADDRESS-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183255500-1.0P-1-1-1.0CA_ADDRESS_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.REASON-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183256550-1.0P-1-1-1.0R_REASON_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.STORE_RETURNS-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183257640-1.0P-1-1-1.0SR_ITEM_SK-1-1
        SR_TICKET_NUMBER-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.TIME_DIM-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183256440-1.0P-1-1-1.0T_TIME_SK-1-1
  Column GroupMCARDF       
           
Table SpacePage SizeExtent SizePrefetch SizePartition Group      
TS000014096 32128IBMDEFAULTGROUP      
  Table NameCARDFNPAGESF      
  DB2ADMIN.DATE_DIM-1-1      
  Index NameCluster FactorUnique RuleNLEAFNLEVELCluster RatioKey Column NameCOLCARDFMCARDF
  DB2ADMIN.SQL090403183255920-1.0P-1-1-1.0D_DATE_SK-1-1
  Column GroupMCARDF