SAP ABAP Table /SDF/ORAIDXINFO (Index Information)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/STPI_DDIC (Package) DDIC for /SDF/STPI Development

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/ORAIDXINFO	Table Relationship Diagram
Short Description	Index Information

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_OWNER	☐			CHAR	30	0
2	INDEX_NAME	☐			CHAR	30	0
3	INDEX_TYPE	☐			CHAR	27	0
4	TABLE_NAME	☐			CHAR	30	0
5	UNIQUENESS	☐			CHAR	10	0
6	BLEVEL	☐			DEC	31	0
7	LEAF_BLKS	☐			DEC	31	0
8	STATUS	☐			CHAR	8	0
9	NUM_ROWS	☐			DEC	31	0
10	DIST_KEYS	☐			DEC	31	0
11	AVG_LEAF_B	☐			DEC	31	0
12	AVG_DATA_B	☐			DEC	31	0
13	CLUST_FACT	☐			DEC	31	0
14	SAMPL_SIZE	☐			DEC	31	0
15	LAST_ANALY	☐			CHAR	14	0
16	COL_COUNT	☐			INT4	10	0
17	FREELISTS	☐			INT4	10	0
18	FREELIST_GROUPS	☐			INT4	10	0
19	DEGREE	☐			CHAR	40	0
20	PARTITIONED	☐			CHAR	3	0
21	TEMPORARY	☐			CHAR	1	0
22	GENERATED	☐			CHAR	1	0
23	SECONDARY	☐			CHAR	1	0
24	BUFFER_POOL	☐			CHAR	7	0
25	GLOBAL_STATS	☐			CHAR	3	0
26	USER_STATS	☐			CHAR	3	0
27	KB_USED	☐			DEC	17	0
28	KB_NEEDED	☐			DEC	17	0
29	IDX_SQ	☐			DEC	5	0
30	MONITORING	☐			CHAR	3	0
31	USED	☐			CHAR	3	0
32	START_MONITORING	☐			CHAR	19	0
33	END_MONITORING	☐			CHAR	19	0
34	COMPRESSION	☐			CHAR	8	0
35	PREFIX_LENGTH	☐			DEC	3	0
36	TABLESPACE_NAME	☐			CHAR	30	0
37	INI_TRANS	☐			DEC	10	0
38	MAX_TRANS	☐			DEC	10	0
39	INITIAL_EXTENT	☐			DEC	30	0
40	NEXT_EXTENT	☐			DEC	30	0
41	MIN_EXTENTS	☐			DEC	30	0
42	MAX_EXTENTS	☐			DEC	30	0
43	PCT_INCREASE	☐			DEC	3	0
44	PCT_THRESHOLD	☐			DEC	3	0
45	PCT_FREE	☐			DEC	3	0
46	CREATED	☐			CHAR	14	0
47	LAST_DDL_TIME	☐			CHAR	14	0
48	INCLUDE_COLUMN	☐			DEC	30	0
49	LOGGING	☐			CHAR	3	0
50	JOIN_INDEX	☐			CHAR	3	0
51	IOT_RED_PKEY_ELIM	☐			CHAR	3	0
52	DROPPED	☐			CHAR	3	0
53	VISIBILITY	☐			CHAR	3	0

History

Last changed by/on	SAP	20140922
SAP Release Created in