SAP ABAP Table DB6PMADVIX_GUI (DB6 CCMS: Index Advisor GUI table (view options))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6PMADVIX_GUI	Table Relationship Diagram
Short Description	DB6 CCMS: Index Advisor GUI table (view options)

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	.INCLUDE	☐				0	0	DB6 CCMS: ADVISE_INDEX explain table structure
2	EXPLAIN_TIME	☐			CHAR	26	0
3	SOURCE_NAME	☐			CHAR	128	0
4	SOURCE_SCHEMA	☐			CHAR	128	0
5	SOURCE_VERSION	☐			CHAR	64	0
6	EXPLAIN_LEVEL	☐			CHAR	1	0
7	STMTNO	☐			INT4	10	0
8	SECTNO	☐			INT4	10	0
9	QUERYNO	☐			INT4	10	0
10	QUERYTAG	☐			CHAR	20	0
11	NAME	☐			CHAR	128	0
12	CREATOR	☐			CHAR	128	0
13	TBNAME	☐			CHAR	128	0
14	TBCREATOR	☐			CHAR	128	0
15	COLNAMES	☐			STRG	0	0
16	UNIQUERULE	☐			CHAR	64	0
17	COLCOUNT	☐			INT4	10	0
18	IID	☐			INT4	10	0
19	NLEAF	☐			DEC	22	0
20	NLEVELS	☐			INT4	10	0
21	FIRSTKEYCARD	☐			DEC	22	0
22	FULLKEYCARD	☐			DEC	22	0
23	CLUSTERRATIO	☐			INT4	10	0
24	CLUSTERFACTOR	☐			DEC	22	0
25	USERDEFINED	☐			INT4	10	0
26	SYSTEM_REQUIRED	☐			INT4	10	0
27	CREATE_TIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
28	STATS_TIME	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
29	REMARKS	☐			CHAR	254	0
30	DEFINER	☐			CHAR	128	0
31	CONVERTED	☐			CHAR	1	0
32	SEQUENTIAL_PAGES	☐			DEC	22	0
33	DENSITY	☐			INT4	10	0
34	FIRST2KEYCARD	☐			DEC	22	0
35	FIRST3KEYCARD	☐			DEC	22	0
36	FIRST4KEYCARD	☐			DEC	22	0
37	PCTFREE	☐			INT4	10	0
38	UNIQUE_COLCOUNT	☐			INT4	10	0
39	MINPCTUSED	☐			INT4	10	0
40	REVERSE_SCANS	☐			CHAR	8	0
41	USE_INDEX	☐			CHAR	40	0
42	CREATION_TEXT	☐			STRG	0	0
43	RUN_ID	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
44	INDEXTYPE	☐			CHAR	4	0
45	EXISTS	☐			CHAR	8	0
46	RIDTOBLOCK	☐			CHAR	1	0
47	INCLCOLS	☐			INT4	10	0
48	ESTM_SIZE	☐			DEC	18	4
49	INCL_COLNAMES	☐			STRG	0	0
50	CREATEIX_BUT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
51	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
52	WD_VISIBILITY	☐			NUMC	2	0
53	REF_WL_BUT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons

History

Last changed by/on	SAP	20110908
SAP Release Created in	710