SAP ABAP Data Element QQRCODTSC (iSeries: Reason Code for Table Scan (Database Monitor))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Data Element	QQRCODTSC
Short Description	iSeries: Reason Code for Table Scan (Database Monitor)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQRCOD
Data Type	CHAR	Character String
Length	2
Decimal Places	0
Output Length	2
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	11	ReasonCode
Medium	21	Reason Code
Long	41	Reason Code
Heading	55	Reason Code for Table Scan

Documentation

Definition

QQRCODTSC describes the reason why the database optimizer chose arrival sequence (table scan) to implement the statement execution.

Value range

T1

No indexes exist.

T2

Indexes exist but none could be used.

T3

Optimizer chose table scan over indexes.

History

Last changed by/on	SAP	20070813
SAP Release Created in