Teradata Statistics Extrapolation: What it is and How it Works
Learn about Teradata Statistics Extrapolation, a technique that allows for reasonable estimations when querying historical data with stale statistics.
Teradata
A collection of 307 issues
Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution
Get a Grip on Clumpy Row Distribution - the Teradata PPI Table.
For this technique to work properly, the primary index in Teradata should not include the partition column(s).
We have all encountered the issue of slow table inserts, where the distribution of rows across all AMPs is even,
Simplify Teradata Development: Avoiding the Pitfalls of Over-Specialization and Large SQL Statements
Learn how specialization in Teradata development can lead to the development of huge SQL statements and how to reduce the risk of bad performance.
A Comprehensive Guide to Teradata Statistics: Common Misconceptions, Best Practices, and Real Reasons Behind Performance Degradation
Learn the truth about Teradata statistics and their impact on system performance. Address common misconceptions, follow best practices, and optimize your system for peak performance.
"Explore Teradata's Shared Nothing Architecture with Our Video Course"
The Teradata Architecture Video Course. This video will give you an overview of the Teradata Shared Nothing Architecture. We will show you how Teradata distributes data evenly across its parallel units and how the components interact.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested
Teradata Physical Storage: Understanding the Technical Details for Performance Optimization
An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table
Introduction to Teradata Recursions
To link records from a primary table with a specific date range from a secondary table, a common requirement is to create a simulated history table with snapshot dates using a change history table with defined timelines. Consider the following illustration:
CREATE TABLE Snapshot_History(PK
The Importance of a Good Data Model for Teradata Performance Optimization
Welcome to part two of our Teradata performance optimization series. In this article, we will delve into how a good data model can prevent future performance issues in data warehousing projects. We will also discuss the drawbacks of taking over operational systems' source definitions directly and th
Implementing Teradata Compression: A Guide to Managing Data Warehouse Capacity and Saving Space
Learn how to use compression as a table column addition to manage your data warehouse's space effectively. Discover constraints and best practices.
Teradata Date Format and Time Values: Common Questions Answered
This article will address some common questions about formatting date and time values in Teradata. Teradata is a powerful relational database management system (RDBMS) that provides various functions to manipulate and manage date and time values. Understanding how to work with date and time data is essential for anyone using