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

History

Last changed by/on	SAP	20140922
SAP Release Created in