Indexing
A collection of 141 issues
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