Parameter
rsdb/prefer_fix_blocking
Short text
Set if fix blocking for FOR ALL ENTRIES is desir
Parameter Description
This parameter is only intended for internal use and must not be changed without explicit instruction from SAP.
An internal table [itab] with entry data is always returned to an ABAP SELECT query with the addition FOR ALL ENTRIES. If the number of entries in [itab] cannot be divided by the maximum blocking factor (that is, max_(in_)blocking_factor or the technical blocking factor limit), then fewer entries (conditions) land on the last statement that was created for the processing of the FOR ALL ENTRIES statement. A new statement is produced. If the same FOR ALL ENTRIES statement is executed very often with a different number of entries in the input table [itab] then different statements up to the maximum blocking factor can be created. This can be avoided by setting this parameter. If this parameter is set to ‘1’ then a maximum of two differently long statements are produced. This occurs by the last entry in the input table being repeated as if [itab] has implicitly been filled to the blocking factor ([itab] is not really modified).
Application Area
Database
Parameter Unit
1 / 0
Default Value
The default value is database-dependent. A common, artifical value (-1) must be specified for technical reasons. The original default values are specified below for each database system. Caution: As these values are changed by kernet patches, take the current default values from SAP Note 48230.
DB2/390
1
DB2 UDB
0
Informix
0
iSeries
1
MaxDB
0
MS SQL Server
0
Oracle
0
Are other parameters affected or dependent?
rsdb/max_blocking_factor, rsdb/max_in_blocking_factor
