1. Home
  2. Resources
  3. SAP Tables
  4. IND_ORA - ORACLE Index Information from dba_indexes

SAP Table IND_ORA

ORACLE Index Information from dba_indexes

IND_ORA (ORACLE Index Information from dba_indexes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IND_ORA to other SAP tables.

IND_ORA table fields

Field Data element Checktable Datatype Length Decimals
OWNER Index owner IND_OWNER CHAR 30 0
INDEX_NAME Index name INDEX_NAME CHAR 30 0
INDEX_TYPE Index Type INDEX_TYPE CHAR 27 0
TABLE_OWNE Table owner TAB_OWNER CHAR 30 0
TABLE_NAME Table Name TABLE_NAME CHAR 30 0
TABLE_TYPE Table type TAB_TYPE CHAR 11 0
UNIQUENESS Uniqueness UNIQUENESS CHAR 10 0
TSP_NAME Tablespace name TSP_NAME CHAR 30 0
INI_TRANS Ini trans INI_TRANS DEC 17 0
MAX_TRANS Max trans MAX_TRANS DEC 17 0
INI_EXT Initial extent SEG_INIT DEC 17 0
NEXT_EXT Next extent SEG_NEXT DEC 17 0
MINEXTS Min extents SEG_MINEXT DEC 17 0
MAXEXTS Max extents SEG_MAXEXT DEC 17 0
PCT_INC Percent increase (dba_segments) PCT_INC DEC 14 0
FLISTS Free lists FLISTS DEC 17 0
FLIST_G Free list groups FLIST_G DEC 17 0
PCT_FREE Pct free PCT_FREE DEC 17 0
BLEVEL B tree level BLEVEL DEC 14 0
LEAF_BLKS Number of leaf blocks in index LEAF_BLKS DEC 14 0
DIST_KEYS Number of distinct keys in index DIST_KEYS DEC 14 0
AVG_LEAF_B Average number of leaf blocks per key AVG_LEAF_B DEC 14 0
AVG_DATA_B Average number of data blocks per key AVG_DATA_B DEC 14 0
CLUST_FACT Clustering factor CLUST_FACT DEC 14 0
STATUS Index Status STATUS_IND CHAR 11 0
NUM_ROWS Number of rows NUMROWS DEC 17 0
LAST_ANAL date of the most recent analysis LAST_ANAL DATS 8 0