| TNAME |
X |
TNAME |
CHAR |
0 |
30 |
0 |
|
Nom de la table |
| ANDAT |
X |
AM_DATE |
CHAR |
30 |
12 |
0 |
|
|
| VWTYP |
|
AM_VWTYP |
CHAR |
42 |
2 |
0 |
|
Type d'utilisation de l'entrée de table |
| AMETH |
|
AM_AMETH |
CHAR |
44 |
4 |
0 |
|
Méthode d'analyse de la collecte de statistiques |
| OPTIO |
|
AM_OPTIO |
CHAR |
48 |
5 |
0 |
|
Taille de l'échantillon pour la collecte de statistiques |
| NROWS |
|
OROWS |
DEC |
53 |
15 |
0 |
|
Number of rows in a table |
| OCCBL |
|
UBLOCKS_KB |
DEC |
61 |
11 |
0 |
|
Used blocks of a table in KB |
| EMPBL |
|
EBLOCKS_KB |
|
67 |
|
|
|
|
| AFREE |
|
OAVG_BFREE |
INT4 |
76 |
10 |
0 |
|
Avg. freespace in a used data base block |
| CHAIN |
|
OCHAINED |
DEC |
80 |
15 |
0 |
|
Number of rows requiring block chaining |
| AROWL |
|
OAVG_ROW_L |
DEC |
88 |
7 |
0 |
|
Average row length (Oracle result) |
| HWMBL |
|
HWBLKS_KB |
|
92 |
|
|
|
|
| INDBS |
|
BBLOCKS_KB |
DEC |
98 |
15 |
0 |
|
Used blocks of an index-Btree (kb) |