SAP ABAP Data Element DB2WP4SJTB (Minimum star join tables)

Hierarchy

☛ 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	DB2WP4SJTB
Short Description	Minimum star join tables

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2INT4U
Data Type	INT4	4-byte integer, integer number with sign
Length	10
Decimal Places	0
Output Length	10
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	Min st.j.t
Medium	20	Min. star join table
Long	24	Minimum star join tables
Heading	24	Minimum star join tables

Documentation

Definition

The value controls if and when a star join will be used in the access path selection process. Possible values are:

• 0 Star join is considered for a query block having 10 or more tables. This is the default value.
• 1, 2, or 3 Star join is always considered.
• 4 to 225 Star join is considered for a query block having at least the specified number of tables.
• more than 226 Star join will never be enabled.

Note that this parameter is effective only when star join is enabled, i.e. if the field 'Star join tables cardinality controls' is not set to -1.
ZPARM name is SJTABLES in DSN6SPRM.
SAP recommends using the default value, i.e. setting the parameter to 0.

History

Last changed by/on	SAP	20070813
SAP Release Created in	710