AUTOSTATS in Viewpoint looks to be doing a good job at finding missing statistics on combinations of columns.
A lot of our tables now have column combinations showing up as 'Missing' in AUTOSTATS.
I have not been able to find the button 'Approve Missing Stats' og 'Create Missing Stats'.
What to do?
Solved! Go to Solution.
Given that the statistics are Automated for given objects, go to Statistics tab in StatsManager portlet and click on "Recommendations" in the right upper corner. You can approve the StatsManager's suggestions there (within 4 categories: Collect/Reactivate/Deactivate/Automate). More on that in Teradata Viewpoint User Guide; Chapter 25: Stats Manager.
That being said, be careful with the recommendations. StatsManager will recommend plenty of statistics that may improve the level of confidence in execution plans, but if the execution plan itself does not change, they are not really necessary. You may end up wasting resources for collecting statistics with no real added value.
Thanks for taking the time to answer me. However the description you give is how I would have expected the AUTOSTATS process to run but not what I see in practice.
As you can see from this screenshot below AUTOSTATS tells me that stats on a combination of columns are missing. But the recommendations in the top right corner says 0.
This confuses me a bit =)
Thanks. This was just the thing.
I guess the accepted changes show up as missing until the next run.