Introduction to Teradata Recursions To link records from a primary table with a specific date range from a secondary table, ...

An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table

This article will address some common questions about formatting date and time values in Teradata. Teradata is a powerful relational ...

Teradata Date Format and Time Values: Common Questions Answered

What is the Teradata Sample Function? The SAMPLE function returns a set of randomly selected rows. Here are the characteristics: ...

Understanding Teradata’s SAMPLE Function: Randomly Select Rows and More

Teradata UNION ALL Introduction Teradata introduced a new Optimizer feature for managing sets of rows combined by UNION ALL in ...

Optimizing Join and Aggregation with Teradata UNION ALL Views

To optimize Teradata SQL performance, it is crucial to identify the root cause of any issues. The SQL statement itself ...

Practical Approach for Teradata SQL Tuning: Finding the Root Cause of Performance Issues

Roland Wenzlofsky’s recent blog introduced the CHAR2HEXINT function, which extracts coding table numbers for tokens. These functions proved invaluable in ...

Extracting Numeric Tokens from Strings with CHAR2HEXINT Function in Teradata SQL

In Teradata Stored Procedures, variable declarations are limited to the surrounding compound statement (BEGIN...END) and all subsequent compound statements.An integer ...

Variable Declarations in Teradata Stored Procedures

Teradata Tuning with Query Rewriting This article explores how to enhance the efficiency of SQL statements through rewriting techniques. This ...

Improving Teradata Performance with SQL Query Rewriting

I want to present two queries for Teradata 14.10 before we delve into the specifics. SELECT * FROM TheTable WHERE ...

Teradata SQL Performance: IN vs BETWEEN and the Use of Statistics on Columns

Longer texts, such as descriptions of other columns, are stored in VARCHAR() columns. The maximum character capacity for storage is ...

Improve Query Performance by Using the Teradata CLOB Datatype for Storing Longer Texts