SAP ABAP Table HDB_EXPLAIN_PLAN_TABLE (Structure for EXPLAIN_PLAN_TABLE for EXPLAIN)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ HAN-DB (Application Component) SAP HANA Database
     ⤷ SDBA_HDB (Package) DBACOCKPIT for NewDB (HDB)

Basic Data

Table Category	INTTAB	Structure
Structure	HDB_EXPLAIN_PLAN_TABLE	Table Relationship Diagram
Short Description	Structure for EXPLAIN_PLAN_TABLE for EXPLAIN

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	STATEMENT_NAME	☐			CHAR	256	0
2	OP_NAME	☐			CHAR	5000	0
3	OP_DETAILS	☐			STRG	0	0
4	EXECUTION_ENGINE	☐			CHAR	256	0
5	SCHEMA_NAME	☐			CHAR	256	0
6	TABLE_NAME	☐			CHAR	256	0
7	TABLE_TYPE	☐			CHAR	5000	0
8	TABLE_SIZE	☐			FLTP	16	16
9	OUTPUT_SIZE	☐			FLTP	16	16
10	SUBTREE_COST	☐			FLTP	16	16
11	OP_ID	☐			INT4	10	0
12	PARENT_OP_ID	☐			INT4	10	0
13	HDB_LEVEL	☐			INT4	10	0
14	HDB_POSITION	☐			INT4	10	0
15	HOST	☐			CHAR	256	0
16	PORT	☐			NUMC	10	0
17	TIMESTAMP	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
18	CONNECTION_ID	☐			INT4	10	0

History

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