Jump to content

Gather Stats Full Schema vs Stale Stats

Recommended Posts



I have a question for you all. We are on - automatic stats gathering not being taken into consideration here.

If I have gathered statistics for an entire schema(initially), then only gather statistics for the tables that go stale, is that considered best practices?

Is this a true statement - If you have gathered the statistics on a table and it never goes stale - are those statistics still accurate?






Share this post

Link to post
Share on other sites

Hi JC, and welcome to the forum!


You ask a great question!


Remember, the only reason to gather cBO stats is to change sql execution plans!


In many systems, there exists only one optimal plan, and you don't ever want to change it!


Anyway, I only reanalyze when I see suboptimal plans, but it depends on the database volatility:


Please read:




This link is also useful:




Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now