Teradata Statistics Collection for Improved Query Performance
Learn how to optimize your Teradata queries with statistics collection. Discover what to collect and what to omit for accurate query estimation.
VantageCloud Lake: Turbocharge Your Data Warehousing with Teradata’s Innovative Solution Widely read
Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational database management system designed to …
Optimizing Teradata Queries: From No Index to Hashed NUSI
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 …
Customize Your Redshift Workload Management System for Optimal Performance
Access the Amazon Redshift Documentation here: https://aws.amazon.com/de/redshift/
Comparing the Architecture of Amazon Redshift and Teradata: Similarities and Differences
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 …
Understanding Teradata Load Isolation Most read
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 also implies accepting inconsistent outcomes. …
Building a Teradata Data Warehouse: Considerations for ETL Process, SQL Queries, and Physical Data Model Popular
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 few concepts, but I intend …
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 that are skewed and those …
Teradata Sample Statistics: When, How, and Why to Use Them
Introduction to Teradata Sample Statistics Discover the optimal utilization of Teradata Sample Statistics, including when, how, and why to implement them. Sample statistics require columns with a high degree of diversity in values. A UPI satisfies this criterion, and only columns with numerous unique values should be considered for collecting sample statistics for the NUPI. …
Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular
Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …