Solution : https://service.sap.com/sap/support/notes/951416 (SAP Service marketplace login required)
Key words :
/analyze table aaa compute statistics, analyze table bbb compute statistics, sql>plan_table_output--------------------------------------------------------------------------------plan hash, ---------------------------------------------------------------------------plan_table_output--------------------------------------------------------------------------------predicate information, drop table aaa, drop table bbb, create table aaa, create table bbb, explain plan forselect, table access full
Related Notes :
| 1116930 | FAQ: Sub-queries |
| 176754 | Problems with CBO and RBO |