SAP Note 690702 - Histograms cause long runtimes on Oracle 9

Composant : Oracle - Backoffice Service Delivery

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

Mots Clés :
sap marketplace oracle 64-bit -> oracle 9, good index storage quality, correct access path solution, correct access paths, ideal access path, undesired access path, performance problems occur, 5 64bit -> hp_ux_64 -> p3317309_9205_hp64, 0 64bit -> oracle 9, access path

Notes associées :

797629FAQ: Oracle histograms
723879Explain: System displays an incorrect access path
706132Composite SAP Note: Problems with Oracle 9i
588668FAQ: Database statistics
484642Processing-intensive SQL statement for the VIAUF_AFVC view
484638Expensive SQL Statement to Join between AFKO and AUFK
365760Expensive SQL Statement on tabel EBKN
365744Expensive SQL Statement on VIQMEL or VIAUFK
364540Expensive Statement auf Join EASTL/EGERH/EQUI
335415Creating and Maintaining Histograms
329914Expensive SQL statements composite note
176754Problems with CBO and RBO