Solution : https://service.sap.com/sap/support/notes/821722 (SAP Service marketplace login required)
Summary :
The SAP Note addresses performance issues occurring when executing joins between the MKPF and MSEG tables on SQL Server platforms (2000, 2005, 2008), particularly underpinned by outdated column statistics for the BUDat field in MKPF. Outdated statistics mislead the SQL Server Query Optimizer into underestimating the volume of recent entries, affecting the choice of an optimal access plan, predominantly when using nested loops for joins which could seriously degrade performance. The recommended solution involves regularly updating the BUDAT column statistics manually through transaction DB02, or by scheduling a job in SQL Server Enterprise Manager, to achieve more accurate query estimations and improved execution plans.
Key words :
sql server query analyzer selects, sql server query optimizer decides, sql server automatically updates statistics, sql server query analyzer, sql server enterprise manager, constant scan nested loops, constant scan merge join, sql server optimizer, microsoft sql server 2000, sql server refreshes
Related Notes :
| 133381 | Database-Hints in Open SQL for MS SQL Server |
| 129385 | Database hints in Open SQL |