|
Oracle9i New Feature Series: Dynamic Optimizer Statistics SamplingDynamic sampling introduced in Oracle9i Release 2 improves server performance by determining more accurate selectivity and cardinality estimates for queries. You can use dynamic sampling to:
Dynamic sampling is controlled by the initialization
parameter
Increasing the value of the
parameter results in more aggressive application of dynamic sampling, in
terms of both the type of tables sampled (analyzed or unanalyzed) and the
amount of I/O spent on sampling. |
To read more: OPTIMIZER_DYNAMIC_SAMPLING
– the parameter Enabling Dynamic Statistic Sampling
|