Solution : https://service.sap.com/sap/support/notes/808060 (SAP Service marketplace login required)
Key words :
transaction db50-> problem analysis -> tables/views/synonymsfor, optimizer chooses inefficient access strategies, avoid undesired line breaks, encounter general performance problems, regularly perform update statistics, large tablesvery large tables, correct access strategy, online transaction processing, important additional information, change operations occur
Related Notes :
| 1466524 | MaxDB: SAMPLE values for update statistics |
| 1396431 | Table lock during UPDATE STATISTCS ESTIMATE (sampling) |
| 1308217 | SAP MaxDB Version 7.8: Parameter recommendations |
| 1229738 | Parallel update statistics as of MaxDB 7.6.05 or 7.7.04 |
| 972648 | 7.5.00.37: View access error (-3007) |
| 958182 | Update Statistics and table DBSTATC |
| 927882 | FAQ: SAP MaxDB Update Statistics |
| 830468 | FAQ: Business Information Warehouse system with SAP MaxDB |
| 819641 | FAQ: SAP MaxDB Performance |
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 797667 | Performance problems in BW system require update statistics |