Global Statistics vs. Histograms with DBMS_STATS Package
Optimisation is the process of choosing the most efficient way to execute a SQL statement. The cost-based optimiser uses statistics to calculate the selectivity of predicates and to estimate the cost of each execution plan.
Views: 1507 | | by Slicer
View this tutorial