I was recently approached to support a case of importing the results of a Teradata query into a third-party vendor ...

Fast multi-file export of Teradata query results using only Teradata SQL Assistant

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, ...

The Teradata AMP Worker Task

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

Hello, data enthusiasts! Today, we're delving into a Teradata SQL scenario focusing on enhancing performance by avoiding full table scans ...

Optimizing Teradata SQL Queries by Avoiding Full Table Scans and Utilizing Secondary Indexes

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

Running out of free Cylinders in Teradata Encountering a situation where free cylinders are exhausted is a significant concern when ...

When Teradata Space Shortage Impacts System Performance

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

Occasionally, it is necessary to utilize a cursor within a stored procedure to execute specific functionality. I recently encountered a ...

Improving Stored Procedure Performance with Teradata MAPS Architecture