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

On this website, you will find many articles about Teradata SQL Tuning. We describe in detail the tools which are ...

The first complete Teradata SQL Tuning Checklist

In this article, we will learn about Teradata set operators, how they work, how we use them to achieve optimal ...

Teradata Set operators simply explained

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

Teradata Antiselect – Usage and Performance Impact

Problem-solving without a Teradata Recursive Query In our example, we want to represent a corporate hierarchy. Without recursion, this can ...

The Teradata Recursive Query for Performance Tuning