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

How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study

The Teradata Tutorial to support the selection of indexes How much space does the Teradata index occupy? An index can ...

Teradata Index Selection: Factors to Consider

1. Complete and up-to-date Statistics At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer ...

The Importance of Up-to-Date Statistics for Teradata SQL Tuning

The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools. ...

Optimizing Teradata Queries: From No Index to Hashed NUSI

The optimizer has various access paths to consider when creating the execution plan, each with unique advantages and disadvantages. This ...

Teradata Access Paths: 8 Essential Ones to Know

This course focuses on Teradata indexing techniques. In this two-hour excursion, you will learn about Teradata’s architecture and Full Table ...

Learn Teradata Indexing Techniques in this 2-Hour Video Course

The Teradata Architecture Video Course. This video will give you an overview of the Teradata Shared Nothing Architecture. We will ...

“Explore Teradata’s Shared Nothing Architecture with Our Video Course”

The Teradata NUSI is an alternative access path to table rows, similar to other relational database indexes. Indexes are used ...

The Teradata NUSI (Nonunique Secondary Index)

Numerous online articles discuss Teradata Hashing, which evenly distributes physical data rows across all AMPs and sorts them based on ...

Understanding Teradata Value Ordering for Improved Range Scans and Data Retrieval

What is the tactical workload in Teradata? Tactical workload tuning is a specialized discipline in Teradata that demands distinct skills ...

Optimizing the Tactical Workload in Teradata: Skills and Tools Needed