Archive

Teradata ORDER BY and Performance Optimization

In Teradata, a simple sort method requiring all rows to be in one place for sorting is impractical, as numerous AMPs store a portion of…

Understanding the Waterfall Model and Its Limitations

A waterfall model is a linear approach to project management, where each phase must be completed before moving on to the next one. The…

The Teradata Primary Index

Teradata, a leading data warehouse and analytics platform, utilizes a unique approach to storing and accessing data using its Primary…

The Teradata Transient Journal

The Teradata Transient Journal is a dictionary table maintained across the system to protect transactions against system failures and…

Teradata MERGE INTO vs. UPDATE

Introduction

Filter efficiently with Teradata NOS (using AWS)

Teradata NOS allows us to query data stored in an S3 object store easily. To achieve optimal performance, it is important to partition the…

Teradata Antiselect

Teradata has adopted a variety of analytical functions from Teradata Aster in the latest releases. While most functions are, in our…

Introduction to Teradata Compression

A small comment at the beginning: Teradata Block Level Compression is since some releases of Teradata always enabled and cannot be…

Teradata vs. Snowflake

In this article, I will explain the main architectural differences between Teradata and Snowflake.

Improve your Teradata Load performance with these simple tricks

What influences the Teradata Load Performance?