Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution

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

This example distinguishes repeated primary-index values from duplicate complete rows. Duplicate-row checking is relevant to SET semantics; a UNIQUE primary index adds a different uniqueness constraint. Measure load costs and partition probing together rather than treating the design as a universal performance fix. Get a Grip on Clumpy Row Distribution – the Teradata PPI Table. For …

Read more

How To Speed Up Your PPI Tables With A Secondary Index

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

Teradata offers various options for designing Partitioned Primary Index Tables. The optimal design choice depends on the anticipated workload. This article examines the impact of partitioning methods on the access path selected by the Teradata Optimizer, ultimately influencing system performance. To begin, a test scenario is required, which consists of two identical tables. The sole …

Read more

Efficiently Load Tables with Teradata Fast Path INSERT/SELECT: Requirements and Advantages

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

Fast Path INSERT/SELECT efficiently loads a single table. Requirements for Teradata Fast Path INSERT /SELECT How does the Fast Path INSERT/SELECT work? This reduces access to mass storage (such as hard disk or solid-state disk). The process involves generating complete data blocks on every AMP and subsequently transferring them to mass storage using a single …

Read more

Optimizing Teradata Joins with Skewed Data: Strategies and Solutions

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

Skewed Teradata Joins – The Initial Situation Consider the scenario where one table includes various currencies while the other comprises customers’ accounts with their corresponding currency. Essentially, the ISO code of the currency serves as a foreign key in the account table. 🎓 Prefer video? Lecture 11 of my Udemy course Teradata Performance Tuning in …

Read more

Teradata Heuristics for Nonindexed Columns Popular

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

Learn about heuristics in Teradata optimizer and how they estimate the number of selected data rows for nonindexed columns in WHERE condition predicates. This post analyzes several queries and their estimates based on heuristics and provides insights on how to replace heuristic estimations with more accurate ones.

Protected by Security by CleanTalk and CleanTalk Anti-Spam