SAP ABAP Table MSSXPLPLAN (Structured output from queries when set showplan_all is on.)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSXPLPLAN	Table Relationship Diagram
Short Description	Structured output from queries when set showplan_all is on.

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	STMTTEXT	☐	MSSXPLTXT		CHAR	2048	0	Text of showplan output
2	STMTID	☐	MSSPLSTMTID	INT4	INT4	10	0	MSS: Plan statement ID
3	NODEID	☐	MSSPLNODEID	INT4	INT4	10	0	MSS: Plan node ID
4	PARENT	☐	MSSPLPARENT	INT4	INT4	10	0	MSS: Plan parent node
5	PHYSICALOP	☐	MSSPLPHYSOP		CHAR	32	0	MSS:Plan physical operation name
6	LOGICALOP	☐	MSSPLLOGOP		CHAR	32	0	MSS: Plan logical operation name
7	ARG	☐	MSSPLARG		CHAR	2048	0	MSS: Plan arguments
8	DEFVAL	☐	MSSPLDEFVAL		CHAR	2048	0	MSS: Plan defined values
9	ESTROWS	☐	MSSPLESTROWS		FLTP	16	16	MSS: Plan estimated rows
10	ESTIO	☐	MSSPLESTIO		FLTP	16	16	MSS: Plan estimated IO
11	ESTCPU	☐	MSSPLESTCPU		FLTP	16	16	MSS: Plan estimated CPU
12	AVGROWSZ	☐	MSSPLAVGROWSZ		INT4	10	0	MSS: Plan average row size
13	TOTSUBTREECO	☐	MSSPLTREECOST		FLTP	16	16	MSS: Plan total subtree cost
14	OUTPUTLIST	☐	MSSPLOUTLST		CHAR	2048	0	MSS: Plan output list
15	WARNINGS	☐	MSSPLWARN		CHAR	64	0	MSS: Plan warnings
16	OPTYPE	☐	MSSPLOPTYPE		CHAR	32	0	MSS: Plan operation type
17	PARALLEL	☐	MSSPLPARALLEL		CHAR	8	0	MSS: Plan parallel flag
18	ESTEXECS	☐	MSSPLESTEXECS		DEC	11	0	MSS: Plan estimated executions

History

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