Solution : https://service.sap.com/sap/support/notes/780433 (SAP Service marketplace login required)
Key words :
terms merge join cartesian mjc runtime _optimizer_new_join_card_computation reason, symptom complex bw queries, merge join cartesians, parameter _optimizer_new_join_card_computation = falsein, longer returned, execution plan, oss notes 753096, oracle bug 3268590, patch set 9, restart oracle
Related Notes :
| 755629 | KKO merge fix for Oracle 9.2.0.5 |
| 753096 | DBMS_STATS: num_distinct = 0 when using ESTIMATE |