Performance Tuning
A collection of 267 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
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
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
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
Unlocking the Power of Teradata Macros: Features, Creation, and Execution
What is a Teradata Macro?
The Teradata macro executes multiple SQL queries in a single transaction, ensuring that all requests are successful or changes to database objects are rolled back.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on Teradata, Snowflake, AI, migrations,
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