TNAME |
✔ |
Table name |
TNAME |
CHAR |
30 |
* |
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 |
|
NROWS |
|
Number of rows in a table |
OROWS |
DEC |
15 |
|
OCCBL |
|
Used blocks of a table in KB |
UBLOCKS_KB |
DEC |
11 |
|
EMPBL |
|
Empty blocks of a table in kb |
EBLOCKS_KB |
DEC |
11 |
|
AFREE |
|
Avg. freespace in a used data base block |
OAVG_BFREE |
INT4 |
10 |
|
CHAIN |
|
Number of rows requiring block chaining |
OCHAINED |
DEC |
15 |
|
AROWL |
|
Average row length (Oracle result) |
OAVG_ROW_L |
DEC |
7 |
|
HWMBL |
|
Empty blocks (kb) above High Water Mark |
HWBLKS_KB |
DEC |
11 |
|
INDBS |
|
Used blocks of an index-Btree (kb) |
BBLOCKS_KB |
DEC |
15 |
|