SAP ABAP Table INDEXES_ST (DB02: dba_indexes (Oracle))

Hierarchy

☛ 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	INTTAB	Structure
Structure	INDEXES_ST	Table Relationship Diagram
Short Description	DB02: dba_indexes (Oracle)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	INDEX_NAME	☐	DB_OBJECT	CHAR81	CHAR	81	0	Object: Name of table or index
2	T_OWNER	☐	TBL_OWNER	CHAR30	CHAR	30	0	Owner
3	TN	☐	DB_OBJECT	CHAR81	CHAR	81	0	Object: Name of table or index
4	UNIQUENESS	☐	UNIQUENESS	CHAR10	CHAR	10	0	Uniqueness
5	PCT_FREE	☐	PCT_FREE_	DEC14	DEC	14	0	PCT_FREE
6	INI_TRANS	☐	INI_TRANS_	DEC14	DEC	14	0	INI_TRANS
7	MAX_TRANS	☐	MAX_TRANS_	DEC14	DEC	14	0	MAX_TRANS
8	FREELISTS	☐	FREELISTS	DEC14	DEC	14	0	Number of process freelists allocated
9	FREE_GROUP	☐	FREE_GROUP	DEC14	DEC	14	0	Number of freelist groups allocated
10	BLEVEL	☐	BLEVEL	DEC14	DEC	14	0	B tree level
11	LEAF_BLKS	☐	LEAF_BLKS	DEC14	DEC	14	0	Number of leaf blocks in index
12	DIST_KEYS	☐	DIST_KEYS	DEC14	DEC	14	0	Number of distinct keys in index
13	AVG_LEAF_B	☐	AVG_LEAF_B	DEC14	DEC	14	0	Average number of leaf blocks per key
14	AVG_DATA_B	☐	AVG_DATA_B	DEC14	DEC	14	0	Average number of data blocks per key
15	CLUST_FACT	☐	CLUST_FACT	DEC14	DEC	14	0	Clustering factor
16	STATUS	☐	STATUS_IND	CHAR11	CHAR	11	0	Index Status

History

Last changed by/on	SAP	19970418
SAP Release Created in