Sign in Subscribe

Indexing

A collection of 141 issues

Doing Teradata Hashing The Right Way

This article presupposes your existing familiarity with the fundamental structure of a Teradata System. As you are aware, the AMPs operate on a Teradata System. The number of AMPs responsible for managing rows stored on their respective virtual disks varies based on the system's size. There may be

Maximizing Performance with Teradata Partitioning Strategies

Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.

Understanding the Teradata Join Index: Benefits, Usage, and Implementation

Learn about the Teradata Join Index, a performance tuning tool that stores pre-joined tables, aggregations, or table content in a different structure. Discover its benefits, what it is used for, and when to use it.

Maximizing Efficiency: How Teradata MAPS Feature Minimizes Downtime and Simplifies Table Distribution

Teradata's MAPS Feature allows for hardware expansion with minimal downtime by delaying table redistribution. Learn how to use MAPS INSERT. SELECT here.

Optimizing Performance with Teradata Summary Statistics

Discover how Teradata summary statistics provide valuable information about the number of rows in a table, helping to optimize performance tuning.

Teradata Primary and Secondary Index: Understanding the Differences and Importance for Performance Tuning

Learn about the Teradata Primary Index and how it differs from a primary key. Discover the benefits of defining a primary index and how many can be created per table.

Teradata TPump: What it is and How it Facilitates Real-Time Data Updates

Discover Teradata TPump, the real-time loading tool for transactional systems. TPump loads one row at a time, allowing concurrent INSERTs and UPDATEs using row hash locks. With TPump, you can throttle statement rates and execute DML functions, all while bypassing some of the limitations of bulk load

Mastering Teradata Recursive Queries: How to Create and Use Them for Shortest Path Problems

Learn how to create Teradata recursive queries using either the WITH RECURSIVE clause or CREATE RECURSIVE VIEW statement in this guide. Explore a real-world example of finding the shortest paths in a graph through a recursive solution.

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

BLC, Row Level Partitioning, and Datablock Size Tuning In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to influence the Teradata table size and, thus, performance. We will create a test scenario based on a customer master

Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits

The Essential Facts About NOPI Tables in Teradata What are Teradata NOPI tables?The rows of a Teradata NOPI table are not distributed evenly across all AMPs using the hashing algorithm, as with a primary index. They are not intended to replace primary index tables but are used in certain