The Impact of Skewing on Teradata demonstrated
Learn how skewing on Teradata can impact query run times with this informative test scenario. Find key figures and observations to help optimize your performance.
Tuning
Evaluating the Accuracy of Table Statistics: Why Collection Date May Not Be Enough
Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table’s statistics with a simple query.
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.
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.
Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command
# Title: Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command What is the DIAGNOSTIC HELPSTATS ON FOR SESSION Command in Teradata? Gathering statistics is a crucial aspect of optimizing performance. Collecting statistics requires resources, and it matters whether they are used only once in the ETL process or cover multiple queries’ workloads …
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 table loaded daily. We will …
Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits
The Essential Facts About NOPI Tables in Teradata Teradata NOPI Table Limitations No SET tables allowed No Identity columns allowed No Row-Level Partitioning allowed No UPDATE, MERGE INTO, or UPSERT allowed No Permanent Journaling is possible It can’t be defined as Queue Tables No UPDATE triggers allowed No Hash Index allowed No Multiload, as its …
Optimizing Teradata Joins: Tips to Reduce Resource Consumption
Joining tables can be costly since each join requires that the rows being joined are on the same AMP. In cases where the two tables possess different primary indices, copying one or both tables’ rows may be necessary, which can cause a high number of I/Os in large tables. The Teradata Optimizer can select from …