Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

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

1 Answer 1

up vote 0 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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