Solution : https://service.sap.com/sap/support/notes/999126 (SAP Service marketplace login required)
Key words :
star query costs 1328non star query costs, terms performance bw bi reason, alter session set events '38089 trace, alter session set events '38088 trace, 1328non star query costs, check note #596423oracle release >=10, note #981875 ==> optimizer merge fix >= #5652782, star query execution path, suppress star transformation based, -transformed query costs
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 981875 | Optimizer merge fix for Oracle 10.2.0.2 |
| 830576 | Parameter recommendations for Oracle 10g |