Sign in Subscribe

Query Optimization

A collection of 72 issues

Understanding Deadlocks in Teradata: Prevention and Handling Strategies

What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1

Exploring the Different Join Methods in Relational Database Systems: Pros, Cons, and Use Cases

Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods

Teradata employs various join methods and techniques to merge the rows of two tables onto a single AMP, which is essential for joining. The combination of join technique and data geography is called the join strategy, and its goal is to reduce resource consumption (CPU seconds, I/Os). Some join

Teradata MERGE INTO vs. UPDATE: Performance Comparison and Limitations

Teradata MERGE INTO vs. UPDATE This article compares the UPDATE statement to the MERGE INTO statement, analyzing their respective performance differences and limitations. The Teradata MERGE INTO statement positively impacts performance by reducing I/O operations through the following properties. * MERGE INTO does not require spool space * MERGE INTO typically

Teradata Tactical Workload

Introduction This blog post discusses tactical workloads on a Teradata system. Despite Teradata's implementation of features that support tactical workloads, this workload category remains challenging to manage. Selecting an optimal physical design is essential to meet user expectations for query speed. Designing the Teradata tactical workload on a

The Importance of Up-to-Date Statistics for Teradata SQL Tuning

What is Teradata Query Rewriting? Top 6 Optimization Techniques Explained

What is Teradata Query Rewriting? Teradata query rewriting is an integral component of the optimization process for Teradata. The optimizer replaces your query with a more efficient and faster version. Both queries must produce identical results. Teradata implements various optimization techniques to enhance performance. Want more practical data engineering analysis

Teradata SQL Tuning: How Query Rewriting Can Reduce Runtime from 40 Minutes to Seconds

It's time to share a new Teradata SQL tuning case study that showcases the impressive impact of query rewriting on performance. We are studying the query below that originally took 40 minutes to run. As a SQL tuning specialist, I always prioritize adding missing statistics and refreshing stale

Teradata vs. Redshift: A Comparison of Join Strategies and Architecture

Understanding Teradata Join Estimation: Heuristics and Importance of Statistics Collection

What is Teradata Join Estimation? This article demonstrates the functioning of Teradata Join Estimation in the absence of statistics. It presents the heuristics employed to estimate row count and emphasizes the importance of collecting statistics on all join columns. Teradata Join Estimation Heuristics The worst-case scenario involves joining two tables