SAP Note 780433 - Merge Join Cartesian with Oracle 9.2.0.5

Component : Oracle - BW ORACLE

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
753096DBMS_STATS: num_distinct = 0 when using ESTIMATE