0

General question on dbms_stats and auto sample size?

what is the impact of having IOTs with overflows and you switch to auto_sample_size and enable approximate NDV .

How does it impact?

  • This is far from a "general question on dbms_stats". Can you give it a specific title, please? – Colin 't Hart Jun 17 '14 at 12:14
0

For the most part, the primary impact is that the stats gather faster. For the vast majority of cases it produces equally good stats, but does it way faster. There are a few edge cases where you can end up with inferior stats from an approximated NDV. But for the vast majority of datasets it's a superior method due to greatly reduced computational intensity.

To compensate for the problem of occasionally inferior stats, you can manually increase the sample size of the stats gather job to increase its accuracy.

If you want to know how it works in great detail, here is a white paper by a subject expert:

http://jonathanlewis.files.wordpress.com/2011/12/one-pass-distinct-sampling.pdf

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.