1. Statistics In the world of Teradata, understanding and managing statistics is crucial for optimizing the performance of your database ...

Optimal Performance with Teradata

All database systems have as an important goal to minimize the number of IOs. This goal can be achieved in ...

Teradata Partition Elimination vs. Snowflake Micro-Partitions

Add Snowflake, BigQuery, Redshift to your Knowledge As a Teradata enthusiast, I’ve optimized several thousand SQL queries in my career. ...

Make money with the Cloud

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

Teradata SQL: Better performance with less code

What is the Teradata TD_WhichMax Function? Each Teradata release adds new SQL features to make our lives easier. While some ...

Tuning with the Teradata TD_WhichMax Function

This article will show a case study from my past projects. It is an implementation in which, from a row ...

Teradata Tuning with PERIOD Data Type

Sometimes you can’t avoid implementing a certain functionality by means of a cursor in a stored procedure. Recently I had ...

Teradata Stored Procedure Tuning with MAPS

In a previous article, Roland explained how to build a data range without touching a physical table by using recursion. ...

Dates ranges and business calendars beyond recursion and Teradata SYS_CALENDAR

Introduction We can often choose between GROUP BY and DISTINCT for aggregations. In terms of content, both options return the ...

Teradata DISTINCT vs. GROUP BY

Teradata MERGE INTO vs. UPDATEIn this article, we compare the UPDATE statement with the MERGE INTO statement and work out ...

Teradata MERGE INTO – the best tricks