The optimizer has various access paths to consider when creating the execution plan, each with unique advantages and disadvantages. This ...

Teradata Access Paths: 8 Essential Ones to Know

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. Primary ...

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations

Teradata Query Parallelism A query on a Teradata system runs parallelly in every step, whether for joining, sorting, or aggregating ...

Teradata Query Parallelism: A closer look at how Teradata’s shared-nothing architecture and parallel processing capabilities deliver exceptional performance.

The Teradata Architecture Video Course. This video will give you an overview of the Teradata Shared Nothing Architecture. We will ...

“Explore Teradata’s Shared Nothing Architecture with Our Video Course”

What is the Teradata Primary Index? The Teradata Primary Index evenly distributes table rows across AMPs using a hashing algorithm ...

Understanding the Teradata Primary Index: Distribution, Hashing Algorithm, and Performance Considerations

This article presupposes your existing familiarity with the fundamental structure of a Teradata System. As you are aware, the AMPs ...

Doing Teradata Hashing The Right Way