GROUP BY vs DISTINCT: How the Teradata Optimizer Determines the Best Aggregation Method
Learn about the differences between GROUP BY and DISTINCT for aggregations in Teradata. The optimizer now selects the…
Read article →
The Teradata Transient Journal
A Teradata Transient Journal is a dictionary table maintained across the whole system to protect transactions against…
Read article →
How the Teradata Product Join outperforms the Merge Join!
Teradata uses different join methods and has different ways to bring the rows of the two tables to a common AMP, which…
Read article →
Improve your Teradata Load performance with these simple tricks
What influences the Teradata Load Performance? Teradata allows only a limited number of bulk loads to be executed…
Read article →
Character data types as performance killers for the Teradata Primary Index
The Teradata Primary Index and Hash Collisions Typically it makes no difference whether we use INTEGER data types or…
Read article →
Teradata MERGE INTO – the best tricks
Teradata MERGE INTO vs. UPDATE In this article, we compare the UPDATE statement with the MERGE INTO statement and work…
Read article →
Teradata Sparse Maps
Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum…
Read article →
Teradata denormalization as a last resort
Introduction Many data warehouse projects are a failure because an inappropriate data model is chosen at the beginning…
Read article →