An earlier blog post focused on simple steps to get started using the Teradata 14.10 Automated Statistics Management (AutoStats) feature. One of the new capabilities that AutoStats relies on when it streamlines statistics collection is the new “Threshold” option. Threshold applies some intelligence about when statistics actually need to be re-collected, allowing the optimizer to skip some recollections.
Although you will probably want to begin relying on AutoStats when you get to 14.10, you don’t have to be using AutoStats to take advantage of threshold, as the two features are independent from one another. This post will give you a simple explanation of what the threshold feature is, what default threshold activity you can expect when you get on 14.10, and what the options having to do with threshold do for you. And you’ll get some suggestions on how you can get acquainted with threshold a step at a time.