Solution : https://service.sap.com/sap/support/notes/335415 (SAP Service marketplace login required)
Key words :
update dbstatc set ameth = 'eh', optimizer statistics control table dbstatc, normal update statistics run, indexed columns sample 3 percent, > -method ehalso set, records returned significantly, terms performance reason, desired access path, downward-compatible version, required analysis method
Related Notes :
| 797629 | FAQ: Oracle histograms |
| 750631 | Approximations for cost calculation of the CBO |
| 690702 | Histograms cause long runtimes on Oracle 9 |
| 514221 | Techn.object:Long runtimes when displaying implemntd equpmts |
| 484642 | Processing-intensive SQL statement for the VIAUF_AFVC view |
| 484638 | Expensive SQL Statement to Join between AFKO and AUFK |
| 394242 | Runtime problems w/ supply source determtn w/ material class |
| 365760 | Expensive SQL Statement on tabel EBKN |
| 365744 | Expensive SQL Statement on VIQMEL or VIAUFK |
| 364540 | Expensive Statement auf Join EASTL/EGERH/EQUI |
| 336295 | Expensive SQL Statement on matchcode M_MBMPS |
| 182758 | CBO: Create histograms / new internal rules |
| 176754 | Problems with CBO and RBO |
| 106047 | DB21: Customizing the DBSTATC |