Teradata Statistics Design for High Performance: An Introduction
Learn how Teradata 14.10 simplifies statistics collection for better performance. Discover new features that identify unused and missing statistics.
object use count
Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)
Teradata introduced several new features, including one that caught our attention: object use counts (OUC). This feature optimizes the calculation of extrapolated statistics, improving query performance significantly. Before version 13.10, changes made by DML statements were not logged, and the optimizer relied solely on dynamic amp sampling, leading to incorrect estimates for skewed tables. Additionally, …