Architecture
A collection of 111 issues
Teradata Physical Storage: Understanding the Technical Details for Performance Optimization
A thorough understanding of the Teradata system's technical intricacies is crucial to attaining expertise in performance optimization. Although many of us are knowledgeable about existing optimization opportunities, resolving complex performance issues often requires an in-depth understanding of internal data storage.
Until recently, data storage relied solely on hard
Efficiently Load Tables with Teradata Fast Path INSERT/SELECT: Requirements and Advantages
Fast Path INSERT/SELECT efficiently loads a single table.
Requirements for Teradata Fast Path INSERT /SELECT
* All tables involved have the same primary index.
* The target table is empty.
* Only INSERT statements can be included in the request.
How does the Fast Path INSERT/SELECT work?
This reduces access to
Using Sparse Maps in Teradata 16.10 for Efficient Distribution of Small Tables Across AMPs
Teradata 16.10 introduces Sparse Maps, a feature to place small table rows on one AMP. Learn more about how it can optimize your system here.
Teradata Data Access: Single-AMP vs. All-AMP Binary Search and Sequential Search
How to Reduce Skew in Teradata Joins Using the RANDOM() Function
Natural skew may hinder join performance, but the PDPR capability in Teradata 14 can alleviate this problem. However, PDPR may not detect all potential applications if skewed values are not evident in the statistics.
If your Teradata version is below 14, PDPR is unavailable. To address this, you can use
Understanding Workload Flow Control with DBC. ResUsageSAWT Table in Teradata 14.10 and Later Versions
Learn how to analyze workload in Teradata using the DBC.ResUsageSAWT table. This guide explores the essential columns and measures to consider.
Understanding Teradata Express Requests and How They Work with AMPs
Learn how express requests work in Teradata, bypassing stages like syntax checking and permission checking, and how Teradata 14.10 offers a new feature to expedite them.
The Teradata NUSI (Nonunique Secondary Index)
The Teradata NUSI is an alternative access path to table rows, similar to other relational database indexes. Indexes are used to minimize resource consumption, especially IOs. Unlike Oracle, Teradata employs a hashing method for indexing, which is a common method for shared-nothing database systems. Amazon Redshift and Postgres-based database systems
Teradata PPI: Understanding Partitioned Primary Index for Improved Performance
Learn about the benefits of partitioned primary index (PPI) in Teradata, a method for reducing I/Os and improving performance in database systems.