Teradata Join Strategies: The 4 Principal Join Methods
Teradata joins are expensive. We show you how to create quick queries by simply controlling the…
Read issue →Teradata Data Blocks and Storage Demographics
What a Teradata data block holds, explained with a housing analogy, and why the layout decides how…
Read issue →Teradata vs SQL Server: Architecture and Performance
Where Teradata and SQL Server actually differ: data distribution, COUNT(*), large objects and…
Read issue →Teradata Dynamic Workload Management (TASM) Explained
The dynamic workload features TASM has and TIWM does not: event-driven changes, plus time-based and…
Read issue →Teradata on AWS: Security, Backups and Sizing
Do you want to know what changes when you move Teradata to the cloud? I'll show you all that you…
Read issue →Teradata Physical Storage Explained
How Teradata physically stores rows: data blocks, cylinders and the demographics that decide how…
Read issue →Teradata ALTER TABLE vs INSERT INTO: Which Is Faster?
ALTER TABLE or INSERT INTO a new table? A measured comparison on a large table, and which one…
Read issue →Teradata UNION ALL Views for Faster Joins
A different way to handle rows combined with UNION ALL in views and derived tables, and the…
Read issue →