SAP ABAP Table DB6_VIEW_INDEX_ADVISOR (DB6: View Data of action CL_DB6_ACTION_INDEX_ADVISOR)

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	DB6_VIEW_INDEX_ADVISOR	Table Relationship Diagram
Short Description	DB6: View Data of action CL_DB6_ACTION_INDEX_ADVISOR

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	USERDEFINED_TAB	☐	DB6PMADVIX_TAB		TTYP	0	0
2	RECOMMENDED_TAB	☐	DB6PMADVIX_TAB		TTYP	0	0
3	EXISTING_TAB	☐	DB6PMADVIX_TAB		TTYP	0	0
4	VIRTINDEXES_TAB	☐	DB6PMADVIX_GUI_TAB		TTYP	0	0
5	ADVISE_WORKLOAD	☐	DB6PMADVWL_TAB		TTYP	0	0
6	BASETABLE_WORKLOAD	☐	DB6PMADVWL_TAB		TTYP	0	0
7	BASETABLE_WORKLOAD_TITLE	☐			STRG	0	0
8	BASETABLE_WORKLOAD_VISIBLE	☐			CHAR	1	0
9	E_UNIQUE	☐			CHAR	1	0
10	E_TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
11	E_TABSCHEMA	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
12	E_IXNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
13	E_IID	☐			INT4	10	0
14	E_ALLOWRS	☐			CHAR	1	0
15	E_IXCOLS	☐	DB6_TABCOL_DESCR_TAB		TTYP	0	0
16	E_INCIXCOLS	☐	DB6_TABCOL_DESCR_TAB		TTYP	0	0
17	E_TABCOLS	☐	DB6_TABCOL_DESCR_TAB		TTYP	0	0
18	E_TABLE_VALID	☐			CHAR	1	0
19	E_SORT_ORDERS	☐	DBAKEYVAL_TAB		TTYP	0	0
20	EXPLAIN_MODE	☐	DB6_EDITOR_LINE		CHAR	255	0	DB6: Editor Line
21	EXPLAIN_MODES_WD	☐	DBAKEYVAL_TAB		TTYP	0	0
22	C_TBNAME	☐			CHAR	30	0
23	C_TBSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
24	C_DDICNAME	☐			CHAR	3	0
25	C_DBNAME	☐			CHAR	30	0
26	C_DDICLANGU	☐			LANG	1	0
27	C_UNIQUE	☐			CHAR	1	0
28	C_DDICDESCR	☐			CHAR	60	0
29	EXEC_MODE	☐			STRG	0	0
30	EXEC_MODES	☐	DBAKEYVAL_TAB		TTYP	0	0
31	IXDETAILS_VISIBLE	☐			CHAR	1	0
32	SQL_INPUT	☐			STRG	0	0
33	DB2ADVIS_OUTPUT	☐			STRG	0	0
34	DB2ADVIS_RUNNING	☐			CHAR	1	0
35	DB2ADVIS_TRIGGER_ACTIVE	☐			CHAR	1	0
36	DB2ADVIS_AUTOUPT_DELAY	☐			INT4	10	0
37	INDEXES_VISIBLE_ROWS	☐			INT4	10	0
38	R_CREATION_TEXT	☐			STRG	0	0
39	R_NAME	☐			CHAR	128	0
40	R_OLD_IX_DB_NAME	☐	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
41	R_INDEXNAME	☐			CHAR	3	0
42	R_REPLACE_PRMKEY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
43	R_PRMKEY_COL_LIST	☐			STRG	0	0
44	R_TABSCHEMA	☐			CHAR	128	0
45	R_TABNAME	☐			CHAR	128	0
46	DDL_VISIBLE	☐			CHAR	1	0

History

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