SAP Note 750631 - Approximations for cost calculation of the CBO

Composant : Oracle - Backoffice Service Delivery

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 :

927295FAQ: Oracle system statistics
912620FAQ: Oracle indexes
881083Blocking factors on Oracle-based systems
832343FAQ: Clustering factor
806554FAQ: I/O-intensive database operations
797629FAQ: Oracle histograms
789011FAQ: Oracle memory areas
772497FAQ: Oracle Hints
766349FAQ: Oracle SQL optimization
724545Adjusting the CBO statistics manually using DBMS_STATS
723879Explain: System displays an incorrect access path
651060FAQ: Oracle Parallel Execution
601395Collecting system statistics with BRCONNECT
588668FAQ: Database statistics
335415Creating and Maintaining Histograms
176754Problems with CBO and RBO