Parameter
rsdb/prefer_in_itab_opt
Short text
set if IN (…) shall be used for FOR ALL ENTRIE
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 “1” then a statement refers to a statement with an IN clause where only one field in the WHERE clause depends on the internal table that was copied. However this is only possible if the field reference and WHERE condition are sufficiently simple. In effect, the field reference must deal with a non-negated EQ condition.
Example
If the parameter rsdb/prefer_in_itab_opt is set to “1”, then the open SQL statement
SELECT … FOR ALL ENTRIES IN itab WHERE f = itab-f.
maps the following SQL statement
SELECT … WHERE f IN (itab[1]-f, itab[2]-f, …, itab[N]-f)
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 kernel patches, take the current default values from SAP Note 48230.
DB2/390
1
DB2 UDB
1
Informix
1
iSeries
1
MaxDB
1
MS SQL Server
1
Oracle
1
Are other parameters affected or dependent?
No
