SAP ABAP Table IND_ORA (ORACLE Index Information from dba_indexes)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBO (Package) Database Administration: Oracle-Specific Components
Basic Data
Table Category INTTAB    Structure 
Structure IND_ORA   Table Relationship Diagram
Short Description ORACLE Index Information from dba_indexes    
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 OWNER IND_OWNER CHAR30 CHAR 30   0   Index owner  
2 INDEX_NAME INDEX_NAME CHAR30 CHAR 30   0   Index name  
3 INDEX_TYPE INDEX_TYPE CHAR27 CHAR 27   0   Index Type  
4 TABLE_OWNE TAB_OWNER CHAR30 CHAR 30   0   Table owner  
5 TABLE_NAME TABLE_NAME CHAR30 CHAR 30   0   Table Name  
6 TABLE_TYPE TAB_TYPE CHAR11 CHAR 11   0   Table type  
7 UNIQUENESS UNIQUENESS CHAR10 CHAR 10   0   Uniqueness  
8 TSP_NAME TSP_NAME CHAR_30 CHAR 30   0   Tablespace name  
9 INI_TRANS INI_TRANS DEC17 DEC 17   0   Ini trans  
10 MAX_TRANS MAX_TRANS DEC17 DEC 17   0   Max trans  
11 INI_EXT SEG_INIT DEC17 DEC 17   0   Initial extent  
12 NEXT_EXT SEG_NEXT DEC17 DEC 17   0   Next extent  
13 MINEXTS SEG_MINEXT DEC17 DEC 17   0   Min extents  
14 MAXEXTS SEG_MAXEXT DEC17 DEC 17   0   Max extents  
15 PCT_INC PCT_INC DEC14 DEC 14   0   Percent increase (dba_segments)  
16 FLISTS FLISTS DEC17 DEC 17   0   Free lists  
17 FLIST_G FLIST_G DEC17 DEC 17   0   Free list groups  
18 PCT_FREE PCT_FREE DEC17 DEC 17   0   Pct free  
19 BLEVEL BLEVEL DEC14 DEC 14   0   B tree level  
20 LEAF_BLKS LEAF_BLKS DEC14 DEC 14   0   Number of leaf blocks in index  
21 DIST_KEYS DIST_KEYS DEC14 DEC 14   0   Number of distinct keys in index  
22 AVG_LEAF_B AVG_LEAF_B DEC14 DEC 14   0   Average number of leaf blocks per key  
23 AVG_DATA_B AVG_DATA_B DEC14 DEC 14   0   Average number of data blocks per key  
24 CLUST_FACT CLUST_FACT DEC14 DEC 14   0   Clustering factor  
25 STATUS STATUS_IND CHAR11 CHAR 11   0   Index Status  
26 NUM_ROWS NUMROWS DEC17 DEC 17   0   Number of rows  
27 LAST_ANAL LAST_ANAL DATS DATS 8   0   date of the most recent analysis  
History
Last changed by/on SAP  20110908 
SAP Release Created in