Data Element list used by SAP ABAP Table IND_ORA (ORACLE Index Information from dba_indexes)
SAP ABAP Table
IND_ORA (ORACLE Index Information from dba_indexes) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | AVG_DATA_B | Average number of data blocks per key | ||
| 2 | AVG_LEAF_B | Average number of leaf blocks per key | ||
| 3 | BLEVEL | B tree level | ||
| 4 | CLUST_FACT | Clustering factor | ||
| 5 | DIST_KEYS | Number of distinct keys in index | ||
| 6 | FLISTS | Free lists | ||
| 7 | FLIST_G | Free list groups | ||
| 8 | INDEX_NAME | Index name | ||
| 9 | INDEX_TYPE | Index Type | ||
| 10 | IND_OWNER | Index owner | ||
| 11 | INI_TRANS | Ini trans | ||
| 12 | LAST_ANAL | date of the most recent analysis | ||
| 13 | LEAF_BLKS | Number of leaf blocks in index | ||
| 14 | MAX_TRANS | Max trans | ||
| 15 | NUMROWS | Number of rows | ||
| 16 | PCT_FREE | Pct free | ||
| 17 | PCT_INC | Percent increase (dba_segments) | ||
| 18 | SEG_INIT | Initial extent | ||
| 19 | SEG_MAXEXT | Max extents | ||
| 20 | SEG_MINEXT | Min extents | ||
| 21 | SEG_NEXT | Next extent | ||
| 22 | STATUS_IND | Index Status | ||
| 23 | TABLE_NAME | Table Name | ||
| 24 | TAB_OWNER | Table owner | ||
| 25 | TAB_TYPE | Table type | ||
| 26 | TSP_NAME | Tablespace name | ||
| 27 | UNIQUENESS | Uniqueness |