SAP ABAP Data Element DB2WP4OPTP (Optimizer index prefetch enhancement)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Data Element | DB2WP4OPTP |
| Short Description | Optimizer index prefetch enhancement |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR8 | |
| Data Type | CHAR | Character String |
| Length | 8 | |
| Decimal Places | 0 | |
| Output Length | 8 | |
| 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 | 10 | Opt. enh. |
| Medium | 15 | Opt. enh. |
| Long | 36 | Optimizer index prefetch enhancement |
| Heading | 36 | Optimizer index prefetch enhancement |
Documentation
Definition
If the parameter is set to ON, the DB2 Optimizer is more likely to select an index access path due to factoring in possibility of exploiting sequential prefetch on the index leaf pages. The default value is OFF, but in the SAP environments ON is recommended.
The parameter can be explicitly set in DB2 V5 and V6 only. For DB2 V7 it is ON by default. The corresponding ZPARM is OPTPREF is in DSN6SPRM.
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 630 |
