What are Deadlocks in Teradata? Deadlocks occur when each of two transactions holds the lock on a database object the ...

Minimize Teradata deadlocks!

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

Teradata summary statistics are introduced with Teradata Release 14 and provide the Optimizer with statistics about the number of rows ...

The Teradata Summary Statistics

Teradata ORDER BY and Performance If we chose a simple sort method, all rows would have to be available in ...

How Teradata ORDER BY affects your query performance

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

Like most relational database systems, Teradata creates a copy of each row modified for most DML statements. Teradata uses the ...

The Teradata Transient Journal