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
1. Complete and up-to-date Statistics
At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer employs statistics to formulate the optimal execution plan for our query.
The adequacy of statistics or dynamic AMP sampling varies according to the data demographics.
To initiate optimization, updated statistics
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
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
When designing tables for Teradata, it is important to distribute the rows across all AMPs in the system evenly. For instance, on a 100-AMP system with 100,000 rows, the objective would be to allocate roughly 1,000 rows per AMP.
I agree with the design guideline for many tables
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.