SAP ABAP Table INDEX_STAT (index_stats Cache: Result of VALIDATE Index (Oracle))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
STUO (Package) ORACLE Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
STUO (Package) ORACLE Database Monitor
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | INDEX_STAT |
Table Relationship Diagram 
|
| Short Description | index_stats Cache: Result of VALIDATE Index (Oracle) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  NAME |
DB_OBJECT | CHAR81 | CHAR | 81 | 0 | Object: Name of table or index | ||
| 2 | DATUM |
DATUM | DATUM | DATS | 8 | 0 | Date | ||
| 3 | UZEIT |
UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
| 4 | HEIGHT |
HEIGHT | DEC14 | DEC | 14 | 0 | height of the b-tree | ||
| 5 | BLOCKS |
NUMBER_BLK | DEC14 | DEC | 14 | 0 | Number of blocks | ||
| 6 | LF_ROWS |
LF_ROWS | DEC14 | DEC | 14 | 0 | number of leaf rows (values in the index) | ||
| 7 | LF_BLKS |
LF_BLKS | DEC14 | DEC | 14 | 0 | number of leaf blocks in the b-tree | ||
| 8 | LF_ROW_LEN |
LF_ROW_LEN | DEC14 | DEC | 14 | 0 | sum of the lengths of all the branch blocks | ||
| 9 | LF_BLK_LEN |
LF_BLK_LEN | DEC14 | DEC | 14 | 0 | number of leaf blocks in the b-tree | ||
| 10 | BR_ROWS |
BR_ROWS | DEC14 | DEC | 14 | 0 | number of branch rows | ||
| 11 | BR_BLKS |
BR_BLKS | DEC14 | DEC | 14 | 0 | number of branch blocks in the b-tree | ||
| 12 | BR_ROW_LEN |
BR_ROW_LEN | DEC14 | DEC | 14 | 0 | sum of the lengths of all the branch blocks | ||
| 13 | BR_BLK_LEN |
BR_BLK_LEN | DEC14 | DEC | 14 | 0 | usable space in a branch block | ||
| 14 | DEL_LF_ROW |
DEL_LF_ROW | DEC14 | DEC | 14 | 0 | number of deleted leaf rows in the index | ||
| 15 | DEL_LF_LEN |
DEL_LF_LEN | DEC14 | DEC | 14 | 0 | total length of all deleted rows in the index | ||
| 16 | DIST_KEYS |
DIST_KEYS | DEC14 | DEC | 14 | 0 | Number of distinct keys in index | ||
| 17 | REP_KEYS |
REP_KEYS | DEC14 | DEC | 14 | 0 | how many times the most repeated key is repeated | ||
| 18 | BTREE_SPAC |
BTREE_SPAC | DEC14 | DEC | 14 | 0 | total space currently allocated in the b-tree | ||
| 19 | USED_SPACE |
USED_SPACE | DEC14 | DEC | 14 | 0 | total space that is currently being used | ||
| 20 | PCT_USED |
PCT_USED_ | DEC14 | DEC | 14 | 0 | PCT_USED | ||
| 21 | ROWS_PER_K |
ROWS_PER_K | DEC14 | DEC | 14 | 0 | average number of rows per distinct key | ||
| 22 | BLKS_GETS |
BLKS_GETS | DEC14 | DEC | 14 | 0 | Expected number of consistent mode block gets per row |
History
| Last changed by/on | SAP | 19970110 |
| SAP Release Created in |
