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 |