Streamlining Table Cloning in Teradata and Leveraging Zero-Copy Cloning in Snowflake
Teradata Query Performance Tuning: DWHPro’s Guide
Archive
A collection of 80 issues
Latest
Optimizing Teradata Queries with LIKE Operators
Selecting rows from extensive tables containing billions of rows can be resource-intensive, especially when using a LIKE operator. Direct…
Free Teradata Performance Tuning Course
We are excited to announce that DWHPRO is launching a new, free online course: Teradata Performance Tuning.
Teradata Hash Collisions
Typically, whether we use INTEGER or CHARACTER data types in the Teradata Primary Index is no different. The Teradata hashing algorithm is…
Teradata Partial Redistribution and Partial Duplication
Introduction
Teradata Vantage Cloud Lake
Teradata is competing with new, innovative database systems that can scale in minutes or even seconds, often allowing independent scaling…
Optimal performance with Teradata
1. Statistics
Locating Table Rows in Teradata: From Hash Maps to Data Block Searches
Introduction
Teradata denormalization as a last resort
Introduction
Introduction to Teradata Sparse Maps
Teradata’s hashing architecture and the use of AMPs to evenly divide tables for maximum parallelism have remained consistent since its…