Solution : https://service.sap.com/sap/support/notes/365744 (SAP Service marketplace login required)
Key words :
oracle cost based optimizer, long run timesselect, severe performance problemsif, oracle release 9, performance reason, sql statement, similar statement, view viaufk, terms riqmel20, solution create
Related Notes :
| 690702 | Histograms cause long runtimes on Oracle 9 |
| 335415 | Creating and Maintaining Histograms |
| 334224 | Important notes for creating indexes |
| 61861 | Performance improvement in PM & SM lists (indexes) |