SAP Parameter rsdb/min_blocking_factor - Min. split factor for FOR ALL ENTRIES queries

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 changedwithout explicit instruction from SAP.
An internal table [itab] with entry data is always returned to an ABAPSELECT query with the addition FOR ALL ENTRIES. If this parameter is setto 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 foundin [itab]: Made simpler if "Entries([itab]) <(><<)> max_blocking_factor/ 2" applies.

Work area
Database

Default value
The default value is database-dependent. A common, artifical value (-1)must be specified for technical reasons. The original default values arespecified below for each database system.
Caution
As these values are changed by kernet patches, take the current defaultvalues from SAP Note 48230.
DB2/390
3
DB2 UDB
10
Informix
iSeries
10
MaxDB
MS SQL Server
5
Oracle
10

Other parameter
rsdb/prefer_fix_blocking, rsdb/max_blocking_factor