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 :
| 951416 | Semijoins and OR clause in inner conditions |
| 841280 | Long runtime with OR and EXIST |
| 176754 | Problems with CBO and RBO |