Sign in Subscribe

Teradata

A collection of 307 issues

Comparing the Architecture of Amazon Redshift and Teradata: Similarities and Differences

Understanding Teradata Load Isolation

Isolation Levels and their Impact on Performance & Concurrency Isolation is a crucial factor in determining the visibility of transaction integrity to database users. This property guarantees that concurrently executed transactions produce identical results to those executed sequentially. Nonetheless, relinquishing this requirement can enhance transaction concurrency, improving performance. However, this

Teradata Transactions: Main Characteristics and Best Practices

What Are The Main Characteristics Of Transactions in Teradata? What is a transaction?Transactions ensure data integrity. All requests within a transaction must be successful. Otherwise, changes to database objects are not applied. It is an "all or nothing" principle. What is the difference between Teradata Mode and

Shrinking Teradata Tables: Reduce Table Size by 90% with This Simple Trick

Despite implementing Multivalue Compression to minimize the size of our tables, we still require additional space. Shrinking A Teradata Table To A Minimum Size I once used a trick that reduced an already optimized table with multivalue compression to just 10% of its original size. This is a pattern worth

Optimize Teradata UNION ALL with a Single Table Scan Trick

The Idea Behind This Trick for Teradata UNION ALL What if you need to apply a UNION ALL operation to distinct columns within a single table? Typically, the process would involve: SELECT CloseDate FROM Customer UNION ALL SELECT OpenDate FROM Customer ; The drawback of this method is that it scans

Building a Teradata Data Warehouse: Considerations for ETL Process, SQL Queries, and Physical Data Model

This post aims to compile all crucial aspects to be considered while constructing a Teradata Data Warehouse, including the ETL process and SQL queries. This list is just the beginning, and I anticipate receiving valuable feedback from my readers to expand it in the future. Initially, I have provided a

Teradata Access Paths: 8 Essential Ones to Know

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is

Optimizing Teradata Joins: Handling Skewed Workloads with Partial Redistribution and Partial Duplication

How does Teradata handle Skew in Joins? The imbalanced workload is a primary issue that must be addressed in performance optimization. Efficient optimization is crucial for join steps due to the possibility of Teradata transferring significant data volumes between AMPs. The optimizer can perform joins separately for primary index values