Statistics have come a long way since V2R1, where only 100 intervals were supported to collect stats on statements themselves. Following figure shows the evolution of statistics since its release.
Statistics in Teradata keep on evolving, and collecting statistics continues to become more dynamic and less resource-intensive.
Now, let's check out some recommendations to be followed. Statistics collection depends upon many things, as we have seen: data demographics, type of stats, system configuration, and many more things.
There are a few questions that we need to answer ...