Teradata Index Selection: Factors to Consider
The Teradata Tutorial to support the selection of indexes
hash index
Teradata Access Paths: 8 Essential Ones to Know
The optimizer has various access paths to consider when creating the execution plan, each with unique advantages and disadvantages. This article will introduce the 8 most essential access paths. The lack of a hash index may surprise you; however, Teradata has entirely substituted it with the single-table join index and discourages its utilization in the …
“Explore Teradata’s Shared Nothing Architecture with Our Video Course”
The Teradata Architecture Video Course. This video will give you an overview of the Teradata Shared Nothing Architecture. We will show you how Teradata distributes data evenly across its parallel units and how the components interact. http://youtu.be/uwRdLr8sRdY
Teradata Hash Index: Minimizing Disk IOs and Optimizing Rows Access
Learn about the Teradata Hash Index, designed to minimize disk IOs and improve access to rows. Discover how it differs from Single Table Join Indexes.