Easing Into Using the New AutoStats Feature
Everyone with a Teradata Database collects statistics. No way around it. Good query plans rely on it, and we’ve all gotten used to it.
But starting in Teradata Database 14.10 there’s some big changes. Numerous enhancements to the optimizer, some important database changes, a new set of APIs, an added data dictionary table, and a brand new Viewpoint portlet all combine together to produce the Automated Statistics (AutoStats) feature. Used fully, AutoStats can identify statistics the optimizer looked for and found missing, flag unused statistics that you no longer need to collect on, prioritize and execute the stats collection statements, and organize/run your statistics collection jobs in the most efficient way possible.
There’s a lot going on and a lot of choices involved. So what’s the easiest way to start getting familiar with AutoStats? And what’s required with the new DBQL logging options? If you like to build up confidence in a new feature at your own pace, this blog posting offers a few simple steps designed to introduce you to key features and benefits AutoStats.