Solution : https://service.sap.com/sap/support/notes/819324 (SAP Service marketplace login required)
Key words :
/servicecat -> support services -> sap solution management optimization -> sap business process performance optimization, -> sql-optimierer-> index-> primary key-> explain-> command monitor-> resource monitorperformance guidelines, transaction db50 -> kernel threads -> task manager -> active tasks, umew60 - empowering workshop sap db/maxdb performance monitoring, transaction db50 -> problem analysis -> performance -> sql performancethe command monitor, transaction db50 -> problem analysis -> tables/views/synonym, <subquery>join table optimizer table1_column = table2_columnthe search conditions, transaction db50 -> problem analysis -> table/view/synonym, sap profile parameter dbs/ada/register_appl_info, maxdb/sap db performance monitoring & optimizationthis
Related Notes :
| 1497862 | FAQ: SAP MaxDB Shared SQL |
| 994590 | High increase in the temporary data area |
| 928037 | FAQ: SAP MaxDB indexes |
| 927882 | FAQ: SAP MaxDB Update Statistics |
| 819641 | FAQ: SAP MaxDB Performance |
| 808060 | Changing the estimated values for Update Statistics |
| 767635 | MaxDB Version 7.5 parameter settings for OLTP/BW |
| 767598 | Available SAP MaxDB documentation |
| 216208 | Application infos for the performance monitor |
| 191492 | Performance: Customer developments in MM/WM |
| 187906 | Performance: Customer developments in PP and PM |
| 185530 | Performance: Customer developments in SD |
| 48244 | Performanz-Probleme;Select for all entries on view |
| 48230 | Parameters for the SELECT ... FOR ALL ENTRIES statement |