SAP ABAP Table /SDF/SYB_STMT_DATA (Sybase Statement Download)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/STPI_7X (Package) 7.x developments in ST-PI

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/SYB_STMT_DATA	Table Relationship Diagram
Short Description	Sybase Statement Download

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	DL_ID	☐			CHAR	14	0
2	ANALYSIS_ID	☐			CHAR	10	0
3	MATCHED_ANALYSIS_ID	☐			INT4	10	0
4	SORT_ORDER	☐			CHAR	16	0
5	INSTANCEID	☐			INT4	10	0
6	SQL_ID	☐			CHAR	16	0
7	HKEY	☐			DEC	30	0
8	USERID	☐			CHAR	16	0
9	SUSERID	☐			CHAR	16	0
10	DBNAME	☐			CHAR	16	0
11	STMTTYPE	☐			INT4	10	0
12	AUTOPARAMS	☐			CHAR	16	0
13	PARALLELDEGREE	☐			INT4	10	0
14	QUOTEDIDENTIFIER	☐			INT4	10	0
15	TRANSACTIONISOLATIONLEVEL	☐			INT4	10	0
16	TRANSACTIONMODE	☐			INT4	10	0
17	SAAUTHORIZATION	☐			INT4	10	0
18	SYSTEMCATALOGUPDATE	☐			INT4	10	0
19	CACHEDDATE	☐			DEC	30	0
20	OPTIMIZATIONGOAL	☐			CHAR	16	0
21	OPTIMIZERLEVEL	☐			CHAR	16	0
22	USECOUNT	☐			DEC	30	0
23	STATEMENTSIZE	☐			DEC	30	0
24	MINPLANSIZEKB	☐			DEC	30	0
25	MAXPLANSIZEKB	☐			DEC	30	0
26	CURRENTUSAGECOUNT	☐			DEC	30	0
27	MAXUSAGECOUNT	☐			DEC	30	0
28	NUMRECOMPILESSCHEMACHANGES	☐			DEC	30	0
29	NUMRECOMPILESPLANFLUSHES	☐			DEC	30	0
30	METRICSCOUNT	☐			DEC	30	0
31	MINPIO	☐			DEC	30	0
32	MAXPIO	☐			DEC	30	0
33	AVGPIO	☐			DEC	30	0
34	MINLIO	☐			DEC	30	0
35	MAXLIO	☐			DEC	30	0
36	AVGLIO	☐			DEC	30	0
37	MINCPUTIME	☐			DEC	30	0
38	MAXCPUTIME	☐			DEC	30	0
39	AVGCPUTIME	☐			DEC	30	0
40	MINELAPSEDTIME	☐			DEC	30	0
41	MAXELAPSEDTIME	☐			DEC	30	0
42	AVGELAPSEDTIME	☐			DEC	30	0
43	TOTALELAPSEDTIME	☐			DEC	30	0
44	TOTALCPUTIME	☐			DEC	30	0
45	TOTALLIO	☐			DEC	30	0
46	TOTALPIO	☐			DEC	30	0
47	ROWS_READ_PROCESSED	☐			DEC	30	0
48	LIO_ROWS_PROCESSED	☐			DEC	30	0
49	PIO_ROWS_PROCESSED	☐			DEC	30	0
50	LASTUSEDDATE	☐			CHAR	19	0
51	AVGSCANROWS	☐			DEC	30	0
52	MAXSCANROWS	☐			DEC	30	0
53	AVGQUALIFYINGREADROWS	☐			DEC	30	0
54	MAXQUALIFYINGREADROWS	☐			DEC	30	0
55	AVGQUALIFYINGWRITEROWS	☐			DEC	30	0
56	MAXQUALIFYINGWRITEROWS	☐			DEC	30	0
57	LOCKWAITS	☐			DEC	30	0
58	LOCKWAITTIME	☐			DEC	30	0
59	SORTCOUNT	☐			DEC	30	0
60	SORTSPILLEDCOUNT	☐			DEC	30	0
61	TOTALSORTTIME	☐			DEC	30	0
62	MAXSORTTIME	☐			DEC	30	0
63	PARALLELDEGREEREDUCED	☐			DEC	30	0

History

Last changed by/on	SAP	20140922
SAP Release Created in	2008_1_700