SAP ABAP Table SYB_QPLANVERSION (SYB: historic query plan versions)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_QPLANVERSION	Table Relationship Diagram
Short Description	SYB: historic query plan versions

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	SSQLID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
2	CACHEDDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
3	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
4	SUSERID	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
5	USERNAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
6	OPTGOAL	☐			CHAR	30	0
7	OPTLEVEL	☐			CHAR	30	0
8	PARALLELDEGREE	☐			INT2	5	0
9	TRANSACTIONISOLATIONLEVEL	☐			CHAR	30	0
10	TRANSACTIONMODE	☐			CHAR	30	0
11	HASAUTOPARAMS	☐			CHAR	3	0
12	PLANID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
13	COMPILEDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
14	PLAN_XML	☐			STRG	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in