[转载]Configuration of the SAP-Oracle Database Interface

from:http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f01e743e-a7bf-2c10-399a-bd3cf2074ff3?QuickLink=ora&overridelayout=true

pdf文件本地链接:http://filer.blogbus.com/1064822/resource_10648221275442443a.pdf

与上篇for all entries clause相关部分内容:

Important paramters:

rsdb/prefer_union_all = FALSE | TRUE = 0 | 1 a OR b or UNION
rsdb/prefer_in_itab_opt = FALSE | TRUE = 0 | 1 IN (a, b, …)
rsdb/prefer_join = FALSE | TRUE = 0 | 1 FROM join_table
rsdb/max_blocking_factor = 5 | n max. num. OR or UNION
rsdb/max_in_blocking_factor = 5 | n max. num. IN list elements
rsdb/prefer_fix_blocking = FALSE | TRUE = 0 | 1 last stmt. has fixed length
rsdb/min_blocking_factor = 5 | n min. num. OR or UNION
rsdb/min_in_blocking_factor = 5 | n min. num. IN list elements

how the perfer_join mode
is implemented in database?

rsdb/prefer_join = 1/TRUE (take precedence over prefer_union_all,
prefer_in_itab_opt)
SELECT S0, S1, S2, S3, S4
FROM tab, (SELECT 1 a, 11 b FROM DUAL UNION
SELECT 2 a, 22 b FROM DUAL UNION
SELECT 3 a, 33 b FROM DUAL UNION
SELECT 4 a, 44 b FROM DUAL) itab
WHERE S1 = itab.a
AND S2 = itab.b
AND S3 > 1000

Comments are closed.