Teradata NOS offers us the possibility to easily query data stored in an S3 object store. To achieve optimal performance, ...

Filter efficiently with Teradata NOS

Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, ...

Teradata NOS – Native Object Store – Reading

A normalized data model usually makes it more complex to create performant queries because there are more tables to link ...

Teradata Join Index for Tuning of Relationship Tables

What is the Teradata Primary Index?The Teradata Primary Index distributes the rows of each table evenly across all AMPs. In ...

The Teradata Primary Index explained in detail

More and more often, I experience in projects that Teradata is used as a database for tactical workload or OLTP ...

Teradata Row Partitioning for Tactical Workload

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

1. Complete and up-to-date StatisticsAt the beginning of Teradata SQL Tuning, we always have to deal with statistics. Teradata Optimizer ...

10 tricks to master Teradata SQL Tuning

The primary goal is to show how the number of rows per base table data block impacts selectivity. The example ...

Top Facts about Teradata NUSI Selectivity

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

Understanding Teradata NOPI Tables

Teradata ALTER Table versus INSERT INTO Changing the structure of a Teradata table can require a lot of resources for ...

Teradata ALTER TABLE