SAP Note 841280 - Long runtime with OR and EXIST

Component : Oracle - Sales

Solution : https://service.sap.com/sap/support/notes/841280 (SAP Service marketplace login required)

Key words :
query optimizer converts exist subqueries, database optimizer selects, considerably longer runtime, full table scan, index range scan, semi-join prevents, <-- exist subquery    t_100, exist subqueries, exist require, exist operator

Related Notes :

1116930FAQ: Sub-queries
176754Problems with CBO and RBO