Solution : https://service.sap.com/sap/support/notes/750631 (SAP Service marketplace login required)
Key words :
set explicitly db_file_multiblock_read_count affects multi block read accesses, optimizer_index_cost_adj / 100 index fast full scan 9i, optimizer_index_cost_adj / 100 index unique scan + table access, optimizer_index_cost_adj / 100 index range scan + table access, null constraint ff = num_nulls / num_rows column, cbo makes rough cost calculations, optimizer_index_cost_adj/100 index skip scan max, multi block read mbrc, full table scan 9i, oracle settings affect cost calculation
Related Notes :
| 927295 | FAQ: Oracle system statistics |
| 912620 | FAQ: Oracle indexes |
| 881083 | Blocking factors on Oracle-based systems |
| 832343 | FAQ: Clustering factor |
| 806554 | FAQ: I/O-intensive database operations |
| 797629 | FAQ: Oracle histograms |
| 789011 | FAQ: Oracle memory areas |
| 772497 | FAQ: Oracle Hints |
| 766349 | FAQ: Oracle SQL optimization |
| 724545 | Adjusting the CBO statistics manually using DBMS_STATS |
| 723879 | Explain: System displays an incorrect access path |
| 651060 | FAQ: Oracle Parallel Execution |
| 601395 | Collecting system statistics with BRCONNECT |
| 588668 | FAQ: Database statistics |
| 335415 | Creating and Maintaining Histograms |
| 176754 | Problems with CBO and RBO |