DWHPro Insights

Performance Tuning

You Migrated From Teradata to Spark and Threw Away the One Thing That Made It Fast Popular

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

If you have spent any amount of time working with Teradata, you know that the Primary Index is one of the most important design decisions you make. It determines how data is distributed across AMPs and whether your joins are fast or slow. Choosing the wrong Primary Index is one of the most common causes …

Read more

Data Warehouse of Horrors: 20 Years of Watching Smart People Build Stupid Things

In the projects I remember, a small team—sometimes five or six people—covered the whole warehouse. These staffing numbers and recalled conversations are personal observations, not an industry benchmark. This was the late 1990s. Data warehousing was young. Teradata was the dominant platform. And the people who built these systems understood, from end to end, what …

Read more

BTEQ Multi-Statement Requests: Transaction Boundaries and Migration

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

In BTEQ, request boundaries matter. A semicolon that terminates the first SQL statement at the end of a line sends that request before the next line is read. Adding another semicolon at the start of the next line does not combine an already-submitted request. Correct multi-statement request formatting There is no trailing semicolon on the …

Read more

Why the Same UPDATE Means Something Entirely Different in Teradata and Snowflake Popular

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

At first glance, an UPDATE looks universal.In reality, it’s one of the most misleading similarities between Teradata and Snowflake.The SQL is the same, but the storage, logging, recovery, and performance mechanics are completely different. If you’re migrating from Teradata to Snowflake (or running both), understanding these differences prevents slow jobs, unnecessary costs, and avoidable outages. …

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

Understanding Teradata DBQL Tables and Query Logging Most read

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

Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to collect, and analyze tactical queries.

The Teradata Recursive Query for Performance Tuning

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

Problem-solving without a Teradata Recursive Query To depict a corporate hierarchy in our instance, we can employ a non-recursive approach, illustrated by the query presented below: The above query has several harmful properties: Problem-solving with a Teradata Recursive Query The above recursive query has several benefits: The path is bounded by VARCHAR(1024), and the query …

Read more

The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance

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

Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …

Read more

Comparing the Architecture of Amazon Redshift and Teradata: Similarities and Differences Widely read

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

This post will contrast the architecture of two widely-used database systems. The similarities between Teradata and Amazon Redshift are notable, as much of your knowledge about Teradata can be applied to Amazon Redshift. Although Amazon Redshift stores data in columns permanently, the similarities remain significant. Teradata can store data in columns, though it was not …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam