Teradata 16 Introduces New Features for UNION ALL Queries

Illustration of a stopwatch dial on an orange paint-splash background

Teradata UNION ALL – The New Features of Release 16 Teradata 16 introduces new features for UNION ALL queries that can enhance their performance, although their application is not guaranteed. The Optimizer will opt for executing the query through conventional methods if the cost estimations for the traditional execution plan are lower. It is crucial …

Read more

Teradata Built-In Functions: TO_NUMBER, TRUNC, CEILING, FLOOR, LEAST, GREATEST, ROUND Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

Use TO_NUMBER to parse numeric text, TRUNC to discard decimal digits, and ROUND to round them. FLOOR and CEILING move toward negative and positive infinity respectively. Those differences matter for negative values. A letter-case comparison is not a numeric validator. Lab check: 24 October 2026 · Teradata 20.00.28.81 · BTEQ 20.00.00.11 · BTET. The values …

Read more

Global Teradata System Characteristics Database: Help Us Build It!

Illustration of a person in a suit standing beside a database cylinder

Teradata administrators worldwide face similar challenges. I propose creating a worldwide database containing the characteristics of Teradata systems. This will allow for easy comparison and analysis of performance issues between different systems. My initial report displays the CPU idle time and the number of disk I/O waits for every hour throughout the day. To contribute …

Read more

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

Illustration of a glossy orange database cylinder with data fragments across its surface

 Introduction to Teradata Recursions To link records from a primary table with a specific date range from a secondary table, a common requirement is to create a simulated history table with snapshot dates using a change history table with defined timelines. Consider the following illustration: The proposed solution would resemble this: If the system calendar …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam