Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
Tuning
The Importance of Avoiding SQL Functions on WHERE Condition Columns for Optimizer Performance
Learn why it’s important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer’s chance to apply these techniques by collecting statistics on all join and aggregation columns.
Understanding Teradata Value Ordering for Improved Range Scans and Data Retrieval
Learn about Teradata value ordering, an optimization technique for range scans of 32-bit integers. Read on to understand how it is implemented.
Teradata Partitioning: Row vs. Column for Efficient Data Access
Learn about Teradata Partitioning and how row and column partitioning can minimize data access resource usage. Read on for benefits and examples.
“Boosting Teradata Statistics Performance with New Syntax in Release 14.00”
Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.
Understanding MaxValueLength and Its Importance in Teradata Statistics
Learn about Teradata’s MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
Optimal performance by avoiding CHARACTER columns in the primary index
The Teradata Primary Index and Hash Collisions Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be minimal performance losses, but this …
Teradata Statistics Maintenance: Milestones, Aging and Recollection, Collection Statement Register, and Triggered Partial Recollection Specification
Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.
Optimizing Workload with Teradata’s Sample Statistics Feature
Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.