Data Element list used by SAP ABAP Table INDEX_STAT (index_stats Cache: Result of VALIDATE Index (Oracle))
SAP ABAP Table
INDEX_STAT (index_stats Cache: Result of VALIDATE Index (Oracle)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | BLKS_GETS | Expected number of consistent mode block gets per row | ||
| 2 | BR_BLKS | number of branch blocks in the b-tree | ||
| 3 | BR_BLK_LEN | usable space in a branch block | ||
| 4 | BR_ROWS | number of branch rows | ||
| 5 | BR_ROW_LEN | sum of the lengths of all the branch blocks | ||
| 6 | BTREE_SPAC | total space currently allocated in the b-tree | ||
| 7 | DATUM | Date | ||
| 8 | DB_OBJECT | Object: Name of table or index | ||
| 9 | DEL_LF_LEN | total length of all deleted rows in the index | ||
| 10 | DEL_LF_ROW | number of deleted leaf rows in the index | ||
| 11 | DIST_KEYS | Number of distinct keys in index | ||
| 12 | HEIGHT | height of the b-tree | ||
| 13 | LF_BLKS | number of leaf blocks in the b-tree | ||
| 14 | LF_BLK_LEN | number of leaf blocks in the b-tree | ||
| 15 | LF_ROWS | number of leaf rows (values in the index) | ||
| 16 | LF_ROW_LEN | sum of the lengths of all the branch blocks | ||
| 17 | NUMBER_BLK | Number of blocks | ||
| 18 | PCT_USED_ | PCT_USED | ||
| 19 | REP_KEYS | how many times the most repeated key is repeated | ||
| 20 | ROWS_PER_K | average number of rows per distinct key | ||
| 21 | USED_SPACE | total space that is currently being used | ||
| 22 | UZEIT | Time |