SAP Note 756335 - Statistics in tables w/ heavily fluctuating volumes of data

Composant : Oracle - Backoffice Service Delivery

Solution : https://service.sap.com/sap/support/notes/756335 (Connexion à SAP Service Marketplace requise)

Mots Clés :
statistics provide good access plans, produce incorrect access paths, related incorrect cbo decisions, abap load table d010l, incorrect access paths due, experience large data growth, dbstatc statistics control table, access paths continue, experience long runtimes, /sapapo/pegkey d010l

Notes associées :

1020260Delivery of Oracle statistics (Oracle 10g, 11g)
766349FAQ: Oracle SQL optimization
742950Performance affected on Oracle DB with Supplement 11
724545Adjusting the CBO statistics manually using DBMS_STATS
706478Preventing Basis tables from increasing considerably
448380Information: Oracle Package DBMS_STATS
176754Problems with CBO and RBO
122718CBO: Tables with special treatment