Teradata Index Selection: Factors to Consider
The Teradata Tutorial to support the selection of indexes

The Teradata Tutorial to support the selection of indexes
Hash indexes remain supported: creation executed in the isolated fixture. Single-table join indexes offer overlapping and broader capabilities, but have not made hash indexes nonexistent. 🎓 Prefer video? Lecture 6 of my Udemy course Teradata Performance Tuning in Practice, “The access paths the optimizer can choose”, covers this topic. See the course on Udemy → …
This historical video introduces Teradata’s classic shared-nothing architecture and component interactions. Hashing does not guarantee even data or workload distribution: primary-index values, maps and intermediate-result skew matter. Platform-specific details in the recording should be checked against current documentation. http://youtu.be/uwRdLr8sRdY
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.
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
Protected by Security by CleanTalk and CleanTalk Anti-Spam