DB2 LUW Storage Manager (Revision #3)

Object Tab - Display of the Tables and Indexes.

Object Name: Name of the database object
Owner: Owner of the Table
Object Type: Type of the database object
Tablespace: Name of the tablespace containing the Table
Bufferpool: Name of the Bufferpool containing the Table
Table Size: Total Size occupied by the table
Column Count:
Cardinality: 
Data:
Indexes:
Pages Used:
Pages Containing Row:
Occupied Blocks:
Rows that Overflow:
NPAGES:
FPAGES:
Overflow:
Average Row Size:
Code Page:
Compression:
Lock Size:
Partition Mode:
Status:
Create Time:

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Name of the database object
Table Schema: Owner of the Table
Object Type: Whether Sytem or User Index
Tablespace: Name of the tablespace containing the index
Buffer Pool:Name of the Bufferpool containing the index
Index Type: Type of the index
Index Size: Size of the Index
Cardinality: The number of distinct values for a column is called index cardinality
Index Leaf Pages: Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows
Cluster Ratio: The degree of data clustering of the index, represented as a percentage between 0 to 100
Rows: Number of rows in the index
Created On: Date on which this index was most recently analyzed