SAP Note 1116930 - FAQ: Sub-queries

Component : Oracle -

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

Key words :
hash anti-join _always_semi_join            _always_semi_join determines, sort merge anti-join hash, sort merge semi-join hash, nested loop anti-join merge, nested loop semi-join merge, hash semi-join _unnest_subquery, ten million data records, anti-join            anti-joins, single relevant data record, trigger unusual execution plans

Related Notes :

951416Semijoins and OR clause in inner conditions
841280Long runtime with OR and EXIST
176754Problems with CBO and RBO