Performance degradation caused by uneven workload distribution is one of the oldest and most persistent challenges in parallel data warehouse ...

Understanding Skew in Teradata and Snowflake

At first glance, an UPDATE looks universal.In reality, it’s one of the most misleading similarities between Teradata and Snowflake.The SQL ...

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

For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical ...

Teradata Hybrid: Bridge or Destination?

When migrating analytical workloads from Teradata to Snowflake, one subtle but important performance factor often gets overlooked: how the two ...

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

Big files, real risks, and how not to overspend On Snowflake, COPY INTO scales with the number of files, not ...

Migrating Bulk Loads from Teradata to Snowflake

Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions: Broadcast hash joins — ...

Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams

I was recently approached to support a case of importing the results of a Teradata query into a third-party vendor ...

Fast multi-file export of Teradata query results using only Teradata SQL Assistant

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, ...

The Teradata AMP Worker Task

Introduction to Teradata Performance and NOT NULLWelcome to our latest Teradata performance blog post, a series designed to provide valuable ...

Boost Your Teradata Performance – The Critical Role of NOT NULL Declarations