Solution : https://service.sap.com/sap/support/notes/322715 (SAP Service marketplace login required)
Key words :
greatly increased prepare times, prerequisites business warehouse applications, symptom long runtimes occur, sap db 'database manager', complex business warehouse queries, extremely long runtimes, business warehouse environment, sapdb sql optimizer, optimal access strategy, worst case scenario
Related Notes :
| 1112049 | Database crash when setting the parameter JOIN_MAXTAB_LEVEL9 |
| 901377 | MaxDB 7.5/7.6 Parameter recommendations for BW systems |
| 567745 | Composite note BW 3.x performance: DB-specific setting |