TNAME |
✔ |
Table name |
TNAME |
CHAR |
30 |
* |
DB6TOWNER |
✔ |
Table Owner (Same as Table Schema) |
|
CHAR |
8 |
|
ANDAT |
|
Analysis date (yyyymmddhhmm) |
AM_DATE |
CHAR |
12 |
|
VWTYP |
|
Type of Usage of Table Entry |
AM_VWTYP |
CHAR |
2 |
|
AMETH |
|
Analysis Method for Collecting Statistics |
AM_AMETH |
CHAR |
4 |
|
OPTIO |
|
Sample Size for Collection of Statistics |
AM_OPTIO |
CHAR |
5 |
|
DB6CARD |
|
Cardinality (Number of Rows) in a Table |
|
CHAR |
10 |
|
DB6FPAGES |
|
Total Number of Pages Allocated to a Table |
|
INT4 |
10 |
|
DB6NPAGES |
|
Total Number of Pages Containing Table Data |
|
INT4 |
10 |
|
DB6TSIZE |
|
Table Size |
|
INT4 |
10 |
|