Parameter
rsdb/min_blocking_factor
Short text
Min. split factor for FOR ALL ENTRIES queries
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 this parameter is set to a value grater than “0” AND rsdb/prefer_fix_blocking is set to “1”, then two different blocking factors are used: A smaller factor (min_blocking_factor) and a larger factor (max_blocking_factor).
However, the min_blocking_factor is only used if a few entries are found in [itab]: Made simpler if “Entries([itab]) < max_blocking_factor / 2” applies.
Application Area
Database
Default Value
The default value is database-dependent. A common, artificial 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 kernel patches, take the current default values from SAP Note 48230.
DB2/390
3
DB2 UDB
10
Informix
0
iSeries
10
MaxDB
0
MS SQL Server
5
Oracle
10
Are other parameters affected or dependent?
rsdb/prefer_fix_blocking, rsdb/max_blocking_factor
