The Optimizer typically excels in utilizing statistics, yet examining the execution plan and cardinality estimations can sometimes be beneficial. Since ...

How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study

When do you need a fire brigade most? When your house is on fire! When is the best time to ...

Why You Need a Performance Specialist for Your Data Warehouse Project

As a Teradata SQL specialist, skew is a common challenge. In fact, approximately 90% of SQL performance difficulties stem from ...

The Impact of Character Sets on Teradata SQL Performance: A Case Study

Teradata Development – Keep it simple, stupid! Specialization within the workforce has led to a growing issue, which I have ...

Simplify Teradata Development: Avoiding the Pitfalls of Over-Specialization and Large SQL Statements

Welcome to the second part of the Teradata performance optimization series. In this session, we will examine a primary culprit ...

The Importance of a Good Data Model for Teradata Performance Optimization

Teradata 16.10 introduces Sparse Maps, a feature that enables the consolidation of small table rows onto one AMP or one ...

Using Sparse Maps in Teradata 16.10 for Efficient Distribution of Small Tables Across AMPs

Teradata data access is categorized based on the number of AMPs involved and the technique employed to search rows within ...

Teradata Data Access: Single-AMP vs. All-AMP Binary Search and Sequential Search

Teradata UNION ALL Introduction Teradata introduced a new Optimizer feature for managing sets of rows combined by UNION ALL in ...

Optimizing Join and Aggregation with Teradata UNION ALL Views

Query rewriting is a potent approach for enhancing performance in row partition elimination. The ensuing test configuration is rooted in ...

Improving Performance through Query Rewriting with Row Partition Elimination: A Real-World Optimization Example on a 400-Million-Row Table

Some General Teradata Tuning Ideas 1. One change at a Time The Teradata system is highly intricate. It may be ...

Teradata Tuning Ideas: Best Practices and Strategies