Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command Widely read

Illustration of a stopwatch dial on an orange paint-splash background

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” …

Read more

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

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits Widely read

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Teradata Sliding Window Merge Join: A Detailed Explanation Popular

Illustration of a stopwatch dial on an orange paint-splash background

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. …

Read more

Teradata Data Types And Data Modeling

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam