Teradata Primary vs Secondary Index: Differences and When to Use Each Popular
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.

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.
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 simultaneously. Fortunately, Teradata’s recent versions can be configured so that the “COLLECT STATISTIC” …
BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. 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 …
The Essential Facts About NOPI Tables in Teradata Historical NoPI restrictions: check the installed release No SET tables allowed No Identity columns allowed Row-level partitioning is supported for appropriate NoPI table definitions; check the release-specific restrictions. UPDATE is supported: it changed both fixture rows on Teradata Database 20.00.28.81. Check MERGE and other operation restrictions separately …
Summary Today I will show you how to identify the source problem to tune the query’s performance utilizing the unnecessary amount of IO, the UII indicator, and how the WHERE clause placed on a VIEW is evaluated. A WHERE predicate on a view can be pushed into underlying operations. The historical case requires its …
Introduction to the Teradata Sliding Window Merge Join DWH Pro thoroughly analyzes the Teradata sliding window merge join, which has limited available information. Our extensive research provides valuable insights into this process. 🎓 Prefer video? Lecture 10 of my Udemy course Teradata Performance Tuning in Practice, “Sliding-window merge join on partitioned tables”, covers this topic. …
Introduction to Teradata Data Types and Data Modeling Suppose you work in a well-organized environment where diligence and discipline prevail and significant effort is put into designing things right in the beginning. In that case, the following post might seem outlandish to you. Else, read on. In a more “experimental” table design landscape, you will …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
Protected by Security by CleanTalk and CleanTalk Anti-Spam