DWHPro helps thousands of visitors every month to become experts in Teradata and data warehouse design and operations by Roland Wenzlofsky

#30 Mar 28, 2023

Announcing Our Free Online Teradata Performance Tuning Course at DWHPRO! Limited Spots Available!

Hello, I hope this email finds you well! We are excited to announce that DWHPRO is launching a new, free online…

Read issue →
#29 Mar 23, 2023

Don't let hash collisions destroy your performance!

Hi there, Learn about the hidden problem of hash collisions in Teradata Primary Index using CHARACTER columns with…

Read issue →
#28 Mar 18, 2023

Optimal performance with Teradata

Hello, Are you looking to optimize your Teradata database system and achieve peak performance? Look no further! We…

Read issue →
#27 Mar 16, 2023

Locating Table Rows in Teradata: From Hash Maps to Data Block Searches

Hi! Discover how Teradata efficiently locates table rows in our latest article! Learn about the various components…

Read issue →
#26 Mar 14, 2023

Some tricks for faster requests by bypassing the Teradata transient journal.

Hi, In this article, I will show you how to optimize your DML statements by bypassing the Transient Journal: Read the…

Read issue →
#25 Mar 13, 2023

What is more performant in Teradata? MERGE INTO or UPDATE?

Hi, In this article, we compare the performance of an UPDATE statement with a MERGE INTO statement: Read the…

Read issue →
#24 Mar 10, 2023

Filter efficiently with Teradata NOS (using AWS)

Hi, Teradata NOS allows us to query data stored in an S3 object store easily. To achieve optimal performance, it is…

Read issue →
#23 Mar 4, 2023

All about Teradata spoolspace

Hi, What is phantom spool? What is leftover spool? In this article you will learn everything about Teradata…

Read issue →