Indexing
A collection of 141 issues
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
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
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
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
Choosing the Right Teradata Data Types
How Do I Select The Appropriate Data Type In Teradata?
Converting datatypes incurs substantial costs and demands significant CPU resources when dealing with extensive tables.
Incorrect data type selection hinders the execution plan.
This article will discuss selecting appropriate data types for optimal performance.
Want more practical data engineering analysis
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.
What is Teradata Sample Statistics? Sample statistics take only a percentage of rows into account when producing estimates.
What are the Advantages of Sample Statistics?We use Teradata Sample
Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance
Introduction to Teradata Referential Integrity
What is Teradata Referential Integrity?Referential integrity ensures that a value created in a foreign key (FK) column of a referencing (child) table also exists as a primary key (PK) in the referenced (parent) table. The parent table's column does not have to
Maximizing Performance with Multiple Teradata Sessions
Teradata Sessions explained in a few Sentences
What is a Teradata session?A session is a LOGON of a user on a Teradata system through which one or more sequential transactions can be executed. A LOGOFF statement terminates the session.
What are multiple Teradata sessions (e.g., in BTEQ)?For