SAP Note 335415 - Creating and Maintaining Histograms

Component : Backoffice Service Delivery -

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 :

797629FAQ: Oracle histograms
750631Approximations for cost calculation of the CBO
690702Histograms cause long runtimes on Oracle 9
514221Techn.object:Long runtimes when displaying implemntd equpmts
484642Processing-intensive SQL statement for the VIAUF_AFVC view
484638Expensive SQL Statement to Join between AFKO and AUFK
394242Runtime problems w/ supply source determtn w/ material class
365760Expensive SQL Statement on tabel EBKN
365744Expensive SQL Statement on VIQMEL or VIAUFK
364540Expensive Statement auf Join EASTL/EGERH/EQUI
336295Expensive SQL Statement on matchcode M_MBMPS
182758CBO: Create histograms / new internal rules
176754Problems with CBO and RBO
106047DB21: Customizing the DBSTATC