DWHPro Insights

Teradata Vantage

Teradata Hybrid: Bridge or Destination?

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

For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical systems on it. Today, the market is very different. Cloud-native databases such as Snowflake, BigQuery, and Databricks have set new standards in elasticity and simplicity. The question is: what role will Teradata play in this …

Read more

Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale

Illustration of three stacked database storage units of differing heights against abstract chart shapes

When migrating analytical workloads from Teradata to Snowflake, one subtle but important performance factor often gets overlooked: how the two systems handle GROUP BY operations on huge tables. The SQL looks the same, but the execution engines behave differently. If you’ve relied on Teradata for years, you may be surprised by Snowflake’s behavior. GROUP BY …

Read more

The Teradata AMP Worker Task Widely read

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

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, responsible for executing tasks and ensuring the smooth functioning of the system. AWTs are threads that process incoming tasks in the AMP. Each AMP has a finite pool of AWTs, which is shared among all …

Read more

Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars

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

The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and achieve the same result. While the answer is the same, Teradata may use a completely different execution plan based on how the query is expressed. One approach is investing in heavy …

Read more

Negative Impact of Applying Functions to Join Columns in Teradata Joins: Performance Implications and Solutions Widely read

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

Functions on Join Columns and Their Impact on Teradata Performance In many Teradata systems, developers apply functions directly in join conditions to work around data-model inconsistencies.While this approach might seem harmless, it can dramatically affect optimizer decisions and query performance — and often reveals deeper data-model issues. 🎓 Prefer video? Lecture 12 of my Udemy …

Read more

Introduction to Apache Spark: A Powerful Solution for Big Data Processing and Analytics

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction Processing and analyzing large volumes of data quickly and efficiently is essential in today’s data-driven world. Apache Spark, an open-source big data processing engine, is a leading solution for handling massive datasets that offers a fast and flexible alternative to traditional data processing frameworks like Hadoop’s MapReduce. This article introduces Apache Spark, explores its …

Read more

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

How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study

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

The historical threshold and performance results below have not been reproduced on the current release. A 20,000-row functional check confirmed that the former decimal literals 19.332 and 19.333 both selected only integer keys through 19, while 19332 selected keys through 19,332. The SQL cutoffs have been corrected. Teradata NUSI Selectivity and Data-Block Density The goal …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam