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

Illustration of three stacked database units of differing heights inside a circle

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

The Teradata NUSI (Nonunique Secondary Index) Widely read

Illustration of a stopwatch dial on an orange paint-splash background

A Teradata NUSI offers an alternative access path that may reduce resource use. Distribution hashing in another product, such as Redshift, is not evidence that it implements Teradata-style secondary indexes. Teradata has two types of secondary indexes: the Unique Secondary Index (USI) and the Non-Unique Secondary Index (NUSI). Although they may seem similar, these indexes …

Read more

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Protected by Security by CleanTalk and CleanTalk Anti-Spam