rsdb/min_in_blocking_factor

Parameter

rsdb/min_in_blocking_factor

Short text

Min. split factor for FOR ALL ENTRIES queries (I

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. Thsi parameter works the same as rsdb/min_blocking_factor in the case that the FOR ALL ENTRIES additional is used with an IN clause (see rsdb/prefer_in_itab_opt).

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
2

Informix
0

iSeries
10

MaxDB
0

MS SQL Server
10

Oracle
5

Are other parameters affected or dependent?

rsdb/prefer_fix_blocking, rsdb/prefer_in_itab_opt, rsdb/max_in_blocking_factor

You May Also Like

Leave a Reply?