SAP ABAP Table DB6PMADVIX (DB6 CCMS: ADVISE_INDEX explain table structure)
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)
⤷ 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 | Table Relationship Diagram |
Short Description | DB6 CCMS: ADVISE_INDEX explain table structure |
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 | EXPLAIN_TIME | CHAR | 26 | 0 | |||||
2 | SOURCE_NAME | CHAR | 128 | 0 | |||||
3 | SOURCE_SCHEMA | CHAR | 128 | 0 | |||||
4 | SOURCE_VERSION | CHAR | 64 | 0 | |||||
5 | EXPLAIN_LEVEL | CHAR | 1 | 0 | |||||
6 | STMTNO | INT4 | 10 | 0 | |||||
7 | SECTNO | INT4 | 10 | 0 | |||||
8 | QUERYNO | INT4 | 10 | 0 | |||||
9 | QUERYTAG | CHAR | 20 | 0 | |||||
10 | NAME | CHAR | 128 | 0 | |||||
11 | CREATOR | CHAR | 128 | 0 | |||||
12 | TBNAME | CHAR | 128 | 0 | |||||
13 | TBCREATOR | CHAR | 128 | 0 | |||||
14 | COLNAMES | STRG | 0 | 0 | |||||
15 | UNIQUERULE | CHAR | 64 | 0 | |||||
16 | COLCOUNT | INT4 | 10 | 0 | |||||
17 | IID | INT4 | 10 | 0 | |||||
18 | NLEAF | DEC | 22 | 0 | |||||
19 | NLEVELS | INT4 | 10 | 0 | |||||
20 | FIRSTKEYCARD | DEC | 22 | 0 | |||||
21 | FULLKEYCARD | DEC | 22 | 0 | |||||
22 | CLUSTERRATIO | INT4 | 10 | 0 | |||||
23 | CLUSTERFACTOR | DEC | 22 | 0 | |||||
24 | USERDEFINED | INT4 | 10 | 0 | |||||
25 | SYSTEM_REQUIRED | INT4 | 10 | 0 | |||||
26 | CREATE_TIME | DB6TSTAMP | CHAR | 14 | 0 | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | |||
27 | STATS_TIME | DB6TSTAMP | CHAR | 14 | 0 | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | |||
28 | REMARKS | CHAR | 254 | 0 | |||||
29 | DEFINER | CHAR | 128 | 0 | |||||
30 | CONVERTED | CHAR | 1 | 0 | |||||
31 | SEQUENTIAL_PAGES | DEC | 22 | 0 | |||||
32 | DENSITY | INT4 | 10 | 0 | |||||
33 | FIRST2KEYCARD | DEC | 22 | 0 | |||||
34 | FIRST3KEYCARD | DEC | 22 | 0 | |||||
35 | FIRST4KEYCARD | DEC | 22 | 0 | |||||
36 | PCTFREE | INT4 | 10 | 0 | |||||
37 | UNIQUE_COLCOUNT | INT4 | 10 | 0 | |||||
38 | MINPCTUSED | INT4 | 10 | 0 | |||||
39 | REVERSE_SCANS | CHAR | 8 | 0 | |||||
40 | USE_INDEX | CHAR | 40 | 0 | |||||
41 | CREATION_TEXT | STRG | 0 | 0 | |||||
42 | RUN_ID | DB6TSTAMP | CHAR | 14 | 0 | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | |||
43 | INDEXTYPE | CHAR | 4 | 0 | |||||
44 | EXISTS | CHAR | 8 | 0 | |||||
45 | RIDTOBLOCK | CHAR | 1 | 0 | |||||
46 | INCLCOLS | INT4 | 10 | 0 | |||||
47 | ESTM_SIZE | DEC | 18 | 4 |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 710 |