DB6_OPTPROFILE - Optimizer Profiles for SQL Statements

Optimizer Profiles for SQL Statements information is stored in SAP table DB6_OPTPROFILE.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".

Fields for table DB6_OPTPROFILE

Field Name	Description	Is Key	Data Type	Length
TABNAME	table Name	X	CHAR	100
PATTERN	SQL statement start pattern	X	CHAR	510
INACTIVE	inactive hint		CHAR	2
WP_ONLY	hint only for work processes		CHAR	2
GUIDELINE	guideline text		STRG	8
REMARK	for documentation only		STRG	8