The Teradata Primary Index and Hash Collisions Typically it makes no difference whether we use INTEGER data types or CHARACTER data types in the Teradata Primary Index. The Teradata hashing algorithm is highly efficient, and at most, when joining two...

Teradata MERGE INTO vs. UPDATE In this article, we compare the UPDATE statement with the MERGE INTO statement and work out the differences in performance. We also show a MERGE INTO statement’s limitations compared to an UPDATE statement. Considering...

Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum parallelism evenly have been unchanged since the beginning. What is new is the ability to create your hash maps. Hash maps, as we...

Introduction Many data warehouse projects are a failure because an inappropriate data model is chosen at the beginning of the project. I am a proponent of a normalized data model. Unfortunately, it is not necessarily fashionable to store data in a th...

Teradata Spool Space Introduction What is Teradata Spool Space? Teradata Spool Space is a workspace that Teradata uses to store temporary and final results sets. Spool Space is only used temporarily and released when it is no longer needed or automat...

On this website, you will find many articles about Teradata SQL Tuning. We describe in detail the tools which are available to optimize queries. In this article, I want to show you the best way to proceed when you need to optimize a query. The presen...