Indexing
A collection of 141 issues
How to Load a Flat File into an Empty Table with Teradata TPT: A Simple Example
This article illustrates loading a flat file into an empty Teradata table using TPT. The example was successfully tested on Teradata 16.20.
Although TPT does offer a wide range of advanced options for loading files, it can be overwhelming for basic tasks. In this demonstration, I will present a
The Importance of Up-to-Date Statistics for Teradata SQL Tuning
Teradata vs SQL Server: Key Architectural Differences and Performance Implications
This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled "Teradata versus SQL Server" will be periodically updated.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on
Maximizing Performance with Teradata Dynamic AMP Sampling: An Introduction
High-Performance Calculations with Teradata Ordered Analytical Functions
Teradata employs two distinct approaches in Ordered Analytic Functions for preparing the data layout necessary for processing. This article explains both approaches and their respective advantages and disadvantages.
Teradata Ordered Analytical Functions
Teradata Analytic Functions are versatile tools that allow for a wide range of applications. The ability to retrieve
Understanding Teradata Join Estimation: Heuristics and Importance of Statistics Collection
What is Teradata Join Estimation?
This article demonstrates the functioning of Teradata Join Estimation in the absence of statistics. It presents the heuristics employed to estimate row count and emphasizes the importance of collecting statistics on all join columns.
Teradata Join Estimation Heuristics
The worst-case scenario involves joining two tables
Optimizing Queries with LIKE Operator in Teradata
Learn how to optimize LIKE operator queries in Teradata to avoid full table scans and improve performance. Read on for expert tips and tricks.
Designing Small Reference Tables for Teradata: Storing All Rows on One AMP for More Efficient Queries
Optimizing Teradata Stage Table Design for Faster Load Times: The Importance of Data Types and Sizes
Learn how to optimize load times in Teradata by choosing the correct data types and sizes for stage tables. Read on for a real-life example.