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.
Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution
This example distinguishes repeated primary-index values from duplicate complete rows. Duplicate-row checking is relevant to SET semantics; a UNIQUE primary index adds a different uniqueness constraint. Measure load costs and partition probing together rather than treating the design as a universal performance fix. Get a Grip on Clumpy Row Distribution – the Teradata PPI Table. For …
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.
Teradata Statistics: COLLECT STATS and Tested Examples Popular
Learn Teradata COLLECT STATISTICS with tested SQL, before-and-after EXPLAIN estimates, sampling, multicolumn statistics and practical recollection guidance.
“Explore Teradata’s Shared Nothing Architecture with Our Video Course”
This historical video introduces Teradata’s classic shared-nothing architecture and component interactions. Hashing does not guarantee even data or workload distribution: primary-index values, maps and intermediate-result skew matter. Platform-specific details in the recording should be checked against current documentation. http://youtu.be/uwRdLr8sRdY
Teradata Physical Storage: Understanding the Technical Details for Performance Optimization Most read
A thorough understanding of the Teradata system’s technical intricacies is crucial to attaining expertise in performance optimization. Although many of us are knowledgeable about existing optimization opportunities, resolving complex performance issues often requires an in-depth understanding of internal data storage. The physical medium may be HDD, SSD or a cloud storage service, depending on deployment. …
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: The proposed solution would resemble this: If the system calendar …
Implementing Teradata Compression: A Guide to Managing Data Warehouse Capacity and Saving Space Popular
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: CAST, TO_CHAR and TO_DATE Examples Most read
To format a Teradata DATE as text, use TO_CHAR. To convert text into a DATE, use CAST with an explicit input format or TO_DATE. These operations solve different problems: a DATE value does not store the slashes, dashes or month names you see on screen. Verified example: DATE value versus formatted text Lab verification: 22 …
How To Speed Up Your PPI Tables With A Secondary Index
Teradata offers various options for designing Partitioned Primary Index Tables. The optimal design choice depends on the anticipated workload. This article examines the impact of partitioning methods on the access path selected by the Teradata Optimizer, ultimately influencing system performance. To begin, a test scenario is required, which consists of two identical tables. The sole …