Situation and Setup of a Historisation in Teradata Vantage Imagine that the time has come to improve your physical data model. Flawed or obsolete Teradata Vantage historisation design decisions need to be corrected. You are asked to separate tables of the same entity with different attributes. We do not question why there are separate tables …
Teradata introduced several new features, including one that caught our attention: object use counts (OUC). This feature optimizes the calculation of extrapolated statistics, improving query performance significantly. Before version 13.10, changes made by DML statements were not logged, and the optimizer relied solely on dynamic amp sampling, leading to incorrect estimates for skewed tables. Additionally, …
The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools. We will begin with the following test scenario: The data is evenly distributed. To demonstrate the query’s selectivity for the tested indexes we will define later, I assigned a significant portion of rows the same …
To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: As you know, a hashing algorithm distributes a table’s rows to the AMPs. The Foundations The hashing algorithm accepts one or …
How to Abort the Teradata Rollback Executing a DML statement on a sizable table may trigger a prolonged ROLLBACK. In such cases, you must choose between waiting for the ROLLBACK to complete or terminating it. Cancelling a rollback avoids wasting additional resources, particularly when the system cannot run in parallel due to high skew, which …
Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …
How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …
Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be promptly processed. Although SSDs are now predominantly used instead of hard disks, copying data into the main memory remains the slowest operation. The Teradata Write-Ahead Logging (WAL) feature enhances DML performance and boosts data …
Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP Index’s benefits and optimal usage for improving load and query performance. First, let us examine Teradata’s approaches over the …
This post will contrast the architecture of two widely-used database systems. The similarities between Teradata and Amazon Redshift are notable, as much of your knowledge about Teradata can be applied to Amazon Redshift. Although Amazon Redshift stores data in columns permanently, the similarities remain significant. Teradata can store data in columns, though it was not …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.