Archive

How the Teradata Product Join outperforms the Merge Join!

Teradata uses different join methods and has different ways to bring the rows of the two tables to a common AMP, which is a prerequisite…

The Teradata Transient Journal

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

Teradata Spool Space Introduction

What is Teradata Spool Space?

Teradata NOS (Native Object Store)

Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud…

Teradata Partition Elimination vs. Snowflake Micro-Partitions

All database systems have as an important goal to minimize the number of IOs.

Make money with the Cloud

As a Teradata enthusiast, I’ve optimized several thousand SQL queries in my career. It was fun and satisfying to see how, with a bit of…

Teradata Datab

What is the meaning of the Teradata DatablockSize option?

Tuning the Teradata Nested Join

The most used join strategy is the MERGE join (or its equivalent for row partitioned tables, the row key-based merge join). A join strategy…

Teradata SQL — Better performance with less code

The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and…

Teradata BLC, Row Level Partitioning, and Datablock Size Tuning

In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be…