Solution : https://service.sap.com/sap/support/notes/750631 (Connexion à SAP Service Marketplace requise)
Mots Clés :
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
Notes associées :
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 |