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. UPDATE In this article, we compare an UPDATE statement with a MERGE INTO statement and work ...

Teradata MERGE INTO vs. UPDATE

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

Rapid success with Teradata SQL Tuning

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

What is Teradata Query Rewriting? Teradata query rewriting is part of the Teradata optimization process. The optimizer replaces your query ...

Teradata Query Rewriting

It is time to publish another case study about Teradata SQL tuning,  which impressively demonstrates the terrific impact of query ...

Teradata SQL Tuning – Faster Than Lightning

What is the purpose of the Teradata COALESCE function? COALESCE receives a list of scalars as arguments and returns the ...

The Teradata COALESCE Function As Shortcut For CASE Statements