BLC, Row Level Partitioning, and Datablock Size TuningIn this article, we will learn how block-level compression, row-level partitioning, and selection ...

Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning

How to use the Teradata MAPS Architecture? In an earlier article (link to All Rows on One AMP – By ...

The Teradata MAPS Architecture – Great Performance with All Rows on One AMP

The Essential Facts About NOPI Tables in Teradata What are Teradata NOPI tables? The rows of a Teradata NOPI table ...

Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits

Teradata FastExport is a powerful tool for rapidly moving large volumes of data between Teradata Vantage and client utilities. This ...

Maximizing Efficiency with Teradata FastExport: A Powerful Tool for Exporting Large Volumes of Data between Teradata Vantage and Client Utilities

What is a Teradata AMP? Teradata AMP (Access Module Processor) is a critical component in the Teradata system, responsible for ...

Understanding Teradata AMPs and their tasks in a Teradata system

What are Teradata roles? Roles serve to simplify rights management. A user assigned a role automatically has the same rights ...

Teradata Roles: Simplifying Rights Management and Improving Performance

What is the purpose of the Teradata COALESCE function? COALESCE receives a list of scalars as arguments and returns the ...

Teradata COALESCE Function: Purpose, Syntax, Alternative and Data Types

Joining tables can be costly since each join requires that the rows being joined are on the same AMP. In ...

Optimizing Teradata Joins: Tips to Reduce Resource Consumption

  Summary Today I will show you how to identify the source problem to tune the query’s performance utilizing the ...

Unneccessary IO elimination – Teradata View Optimization