Teradata can choose from various join methods. The most common ones are Merge Join, ...

​Read More

What is Teradata Join Estimation? This article shows how Teradata Join Estimation works when ...

​Read More

Joining tables is one of the most expensive operations of an SQL statement. This ...

​Read More

Teradata 16 – UNION ALL Starting with Teradata 16, the optimizer has an additional ...

​Read More

When comparing the performance of different Teradata join types, we have to consider the ...

​Read More

The following case study shows how we can sometimes improve query performance by a ...

​Read More

Joining partitioned tables can be quite expensive, especially if partitions don't match or one ...

​Read More

Sometimes natural skew can become a huge problem, causing bad join performance. The Partial ...

​Read More

Business intelligence tools often create queries with many outer joins. This article proves why outer joins are vulnerable ...

​Read More