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

#46 May 14, 2023

Optimizing Teradata SQL Queries by Avoiding Full Table Scans and Utilizing Secondary Indexes

Hi, Boosting your SQL query performance can be as simple as rethinking the use of functions like COALESCE in the WHERE…

Read issue →
#45 May 12, 2023

Outsmarting Teradata Limitations: A Workaround for Teradata Identity Columns in Volatile Tables

Dear Subscriber, We understand that you may encounter difficulties with Teradata Identity Columns and Volatile Tables.…

Read issue →
#44 May 11, 2023

Boost Database Performance: Master Teradata Space Management!

Hello, Struggling with Teradata space management? Discover essential strategies in our new blog post: Understand the…

Read issue →
#43 May 5, 2023

The Mystery Surrounding Teradata SELECT *

Dear Reader, Have you ever wondered why Teradata SELECT * is often considered slow and resource-intensive, despite…

Read issue →
#42 May 4, 2023

Discover the Power of Teradata DBQL Tables and Query Logging: A Comprehensive Guide

Hi, Unlock the full potential of Teradata DBQL Tables to analyze workload, monitor resource usage, and optimize your…

Read issue →
#41 May 3, 2023

Teradata FastLoad: Bulk Load Your Data Quickly and Efficiently Roland Wenzlofsky

Hi, Discover the ins and outs of Teradata Fastload, a lightning-fast bulk load utility that can dramatically speed up…

Read issue →
#40 Apr 30, 2023

VantageCloud Lake: Turbocharge Your Data Warehousing with Teradata's Innovative Solution

Hi, Explore the evolution of parallel database architectures and how Teradata's shared-nothing architecture delivers…

Read issue →
#39 Apr 25, 2023

Teradata's Quirky Execution Plan Estimations - Can You Solve the Mystery?

Hey, there, Teradata Enthusiasts! 🌟 I hope this email finds you in good spirits and ready for a little detective…

Read issue →