When to use dynamic sampling in SQL optimizer?

In very simple meaning, Optimizer takes a sample of rows from a table to calculate missing statistics. During the compilation of a SQL statement, the optimizer decides whether to use Dynamic Sampling or not by considering whether the available statistic are sufficient or not.
For More Information Please Refer:

You May Also Like to Read: