Introduction to Teradata Performance and NOT NULLWelcome to our latest Teradata performance blog post, a series designed to provide valuable ...

Boost Your Teradata Performance – The Critical Role of NOT NULL Declarations

Teradata Identity Columns and CREATE TABLE AS Facing hurdles with the Teradata Identity columns and Volatile Tables? Buckle up because ...

Outsmarting Teradata Limitations: A Workaround for Teradata Identity Columns in Volatile Tables

Introduction In a row-oriented database engine like Teradata, data is organized and stored in units called data blocks. Each data ...

The Pitfalls of Teradata SELECT * Queries

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

Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars

What is the Teradata TD_WhichMax Function? Teradata releases new SQL features with each update, providing enhanced functionality and improved performance ...

Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption

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

Dates ranges and business calendars beyond recursion and Teradata SYS_CALENDAR

Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and ...

Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata

Have you ever experienced extended waiting times for a table comparison to yield results? Have you ever been compelled to ...

A Teradata HASHROW Table Difference Screening Test

Have you encountered a poorly designed physical data model where object columns are distributed randomly across tables, and you wish ...

Teradata – Merging two change history tables

Introduction When performing data analysis, deciding between using GROUP BY and DISTINCT for aggregations is often necessary. While both approaches ...

Teradata GROUP BY vs. DISTINCT- Aggregation Methods