DWHPro Insights

Transactions

A Beginner’s Guide to Teradata Multiload and Fastload Most read

Icon of a chrome hammer inside an orange circle over a brick pattern

Introduction to Teradata Multiload and Fastload MultiLoad does not run in isolation: how the utilities are throttled as a workload of their own and the smaller-volume alternative in BTEQ. Next steps Next: query logging Review: SET and MULTISET tables Return to the Teradata learning path

Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions

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

Teradata Statistics Histograms – A Short Introduction Many are familiar with the Optimizer’s statistical confidence levels. I was recently surprised to discover that a “high confidence” rating does not guarantee a fully accurate estimation (provided the statistics collected are not stale). While I remain hopeful that my observations may be attributed to a bug, I wanted …

Read more

Teradata Join Strategies: Merge, Hash, Nested and Product Joins Most read

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

Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. 🎓 Prefer video? Lectures 8 and 10 of my Udemy course Teradata Performance Tuning in Practice cover this topic: “Merge, hash, nested and product joins” and “Sliding-window merge join on partitioned tables”. See the course on Udemy → The paired table rows …

Read more

Teradata Performance Tuning: A Practical Guide

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

The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are essential, occasionally accompanied by fortuitous circumstances. I’ll demonstrate the remarkable outcomes that can be attained by rephrasing a query using this example. Assuming this scenario: One table has a minimal number of rows, while the other is partitioned and …

Read more

Introduction to TPT Teradata: Streamline Your Data Loading Widely read

Icon of a chrome hammer inside an orange circle over a brick pattern

Learn about Teradata’s Parallel Transporter Utility (TPT), the all-in-one tool that combines Fastload, Multiload, TPUMP, BTEQ, and Fastexport functionalities. Discover the benefits of TPT’s consistent syntax and parallelism, as well as a comprehensive overview of its operators.

Understanding Deadlocks in Teradata: Prevention and Handling Strategies Widely read

Illustration of a person in a suit standing beside a database cylinder

What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1 is to lock rows in table 2, and …

Read more

How to Simplify Database-to-Database Table Copying with Teradata Parallel Transporter (TPT) and tdload Popular

Icon of a chrome hammer inside an orange circle over a brick pattern

The Teradata Parallel Transporter (TPT) is a Teradata Tools and Utilities (TTU) product. Teradata TPT offers under one roof an SQL-like scripting language that simplifies the syntax of old Teradata Utilities for handling external data (e.g., FastLoad, MultiLoad, TPump, BTEQ, and FastExport). Copying Tables between Teradata Systems A classic approach to perform a database-to-database table …

Read more

Teradata Table Skew: Understanding Natural and Artificial Skew with DBC.TableSizeV Popular

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

Teradata table skew is a common issue encountered while working with the Teradata database. If you’re reading this page, you may have experienced this problem. Common knowledge When searching for Teradata table skew or skew factor online, most or all documentation will refer directly to DBC.TableSizeV for computation. To analyze table skew, the commonly used …

Read more

How Join Indexes Can Optimize Performance in a Normalized Data Model

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

A normalized data model can increase the complexity of creating performant queries due to the higher number of tables that must be linked compared to a denormalized data model. It is essential to select a primary index precisely to optimize queries and joins, enabling them to have a direct access path. However, relationship tables often …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam