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. ...

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 Statistics At the beginning of Teradata SQL Tuning, we always have to deal with statistics. Teradata ...

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

The initial situation without any index In this blog post, I will show you how you can optimize a query ...

A Better Alternative For The Teradata NUSI

How Advanced Is The Teradata Columnar Solution? Three properties characterize a Column Store: Improved compression compared to Row Stores. This ...

What I Like About The Teradata Columnar Solution