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...