Teradata and the Memory Hierarchy
Read article →
Understanding Deadlocks in Teradata: Prevention and Handling Strategies
What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the…
Read article →
Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption
What is the Teradata TD_WhichMax Function? Teradata releases new SQL features with each update, providing enhanced…
Read article →
Teradata Tuning with PERIOD Data Type
This article will show a case study from my past projects. It is an implementation in which, from a row per primary…
Read article →
Improving Stored Procedure Performance with Teradata MAPS Architecture
Occasionally, it is necessary to utilize a cursor within a stored procedure to execute specific functionality. I…
Read article →
“Optimizing Performance with Teradata Summary Statistics: A Guide for Efficient Execution Plans”
Discover how Teradata summary statistics provide valuable information about the number of rows in a table, helping to…
Read article →
How Teradata ORDER BY affects your query performance
Teradata ORDER BY and Performance If we chose a simple sort method, all rows would have to be available in one place…
Read article →
Dates ranges and business calendars beyond recursion and Teradata SYS_CALENDAR
In a previous article, Roland explained how to use recursion to build a data range without touching a physical table.…
Read article →