DWHPro Insights

Teradata Vantage

Understanding Teradata Load Isolation Most read

Illustration of a network graph with circular nodes joined by lines

Isolation Levels and their Impact on Performance & Concurrency Load isolation provides a defined committed view under its supported rules; it is not a blanket serializability or performance guarantee. Feature support and restrictions must be verified for the target deployment. Teradata provides varying degrees of isolation: In the next chapter, we will describe how these …

Read more

Teradata Access Paths: 8 Essential Ones to Know

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

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 → …

Read more

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance Popular

Illustration of a dense isometric network of connected data nodes

Introduction to Teradata Referential Integrity Teradata implements 3 Types of Referential Integrity. 1. What is Standard Referential Integrity? The Standard Referential Integrity checks every Row INSERT, DELETE, or UPDATE immediately to ensure referential integrity. A reference index sub-table is required for referential integrity. Violation of referential integrity results in the failure of execution and generates …

Read more

Maximizing Performance with Multiple Teradata Sessions Popular

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

Teradata Sessions explained in a few Sentences Example 1: Multiple Sessions which do not improve performance Multiple sessions can improve throughput for compatible all-AMP scans or independent tables as well as rowhash access. Benefit depends on workload concurrency and resource contention, not a universal fewer-than-all-AMP rule. Example 2: Multiple Sessions which do improve performance In …

Read more

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

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

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

Read more

Teradata Architecture: How Shared-Nothing Parallelism Works Widely read

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

Teradata Query Parallelism Teradata can execute scans, joins, sorts and aggregations in parallel. The chosen plan determines how many AMPs participate; a primary-index lookup can use one AMP, and dependencies may serialize parts of a request. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and …

Read more

The Importance of Teradata Surrogate Keys Popular

Illustration of a dense isometric network of connected data nodes

What are Teradata Surrogate Keys? A surrogate key is an artificial identifier mapped to a natural key, often INTEGER or BIGINT. Generated identity values need not be gapless or globally increasing in insertion or retrieval order. We can use the ROW_NUMBER() function in Teradata to programmatically generate the surrogate key or an IDENTITY column for …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam