DWHPro Insights

Character Sets

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular

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

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

Read more

The Importance of Teradata Surrogate Keys Popular

Illustration of a dense isometric network of connected data nodes

What are Teradata Surrogate Keys? A surrogate key is an artificial identifier mapped to a natural key, often INTEGER or BIGINT. Generated identity values need not be gapless or globally increasing in insertion or retrieval order. We can use the ROW_NUMBER() function in Teradata to programmatically generate the surrogate key or an IDENTITY column for …

Read more

Achieve Incredible Teradata Join Performance

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

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Read more

The Impact of Character Sets on Teradata SQL Performance: A Case Study Popular

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

As a Teradata SQL specialist, I find skew to be a common challenge. In fact, approximately 90% of SQL performance difficulties stem from skew, based on my experience. However, this article focuses on the potential for minor modifications to yield significant improvements. This article highlights the potential consequences of selecting inappropriate character sets for SQL …

Read more

Optimal Performance by Avoiding CHARACTER Columns in the Primary Index Widely read

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

The Teradata Primary Index and Hash Collisions Primary-index data types, character sets and collations can materially affect hashing, comparison and join conversions. Choose types for correct business semantics and compatible joins; benchmark relevant access paths before changing them. This article addresses a performance issue with CHARACTER columns in the primary index. Although not as apparent …

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

Protected by Security by CleanTalk and CleanTalk Anti-Spam