INDEX_STAT - index_stats Cache: Result of VALIDATE Index (Oracle)
index_stats Cache: Result of VALIDATE Index (Oracle) information is stored in SAP table INDEX_STAT.
It is part of development package STUO in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "ORACLE Database Monitor".
It is part of development package STUO in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "ORACLE Database Monitor".
Fields for table INDEX_STAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| NAME | Object: Name of table or index | X | DB_OBJECT | CHAR | 81 | |
| DATUM | Date | DATUM | DATS | 8 | ||
| UZEIT | Time | UZEIT | TIMS | 6 | ||
| HEIGHT | height of the b-tree | HEIGHT | DEC | 8 | ||
| BLOCKS | Number of blocks | NUMBER_BLK | DEC | 8 | ||
| LF_ROWS | number of leaf rows (values in the index) | LF_ROWS | DEC | 8 | ||
| LF_BLKS | number of leaf blocks in the b-tree | LF_BLKS | DEC | 8 | ||
| LF_ROW_LEN | sum of the lengths of all the branch blocks | LF_ROW_LEN | DEC | 8 | ||
| LF_BLK_LEN | number of leaf blocks in the b-tree | LF_BLK_LEN | DEC | 8 | ||
| BR_ROWS | number of branch rows | BR_ROWS | DEC | 8 | ||
| BR_BLKS | number of branch blocks in the b-tree | BR_BLKS | DEC | 8 | ||
| BR_ROW_LEN | sum of the lengths of all the branch blocks | BR_ROW_LEN | DEC | 8 | ||
| BR_BLK_LEN | usable space in a branch block | BR_BLK_LEN | DEC | 8 | ||
| DEL_LF_ROW | number of deleted leaf rows in the index | DEL_LF_ROW | DEC | 8 | ||
| DEL_LF_LEN | total length of all deleted rows in the index | DEL_LF_LEN | DEC | 8 | ||
| DIST_KEYS | Number of distinct keys in index | DIST_KEYS | DEC | 8 | ||
| REP_KEYS | how many times the most repeated key is repeated | REP_KEYS | DEC | 8 | ||
| BTREE_SPAC | total space currently allocated in the b-tree | BTREE_SPAC | DEC | 8 | ||
| USED_SPACE | total space that is currently being used | USED_SPACE | DEC | 8 | ||
| PCT_USED | PCT_USED | PCT_USED_ | DEC | 8 | ||
| ROWS_PER_K | average number of rows per distinct key | ROWS_PER_K | DEC | 8 | ||
| BLKS_GETS | Expected number of consistent mode block gets per row | BLKS_GETS | DEC | 8 |