Starting with Release 14.00 there are several improvements for Teradata statistics which are worth being described in detail. First of all, you should get comfortable with the new syntax, which you should use from now on. This article will cover the new syntax and discuss its advantages which are available starting with Teradata 14.00 COLLECT STATISTICS COLUMN (A), COLUMN(B), ... , COLUMN(Z)...
Teradata Load Performance
Teradata allows only a limited number of bulk loads to be executed together as they consume a lot of resources.  The precise limit depends on your Teradata system. It will be somewhere in the lower 2-digit area. Whenever the utility limit is reached, additional requests will end up in a workload queue. On a heavily loaded system, this will lead to...

Weekly Report

Fresh Articles

The Teradata Explain Statement

  What is the Teradata Explain Statement? If you are new to Teradata, performance optimization of a single SQL statement can be quite challenging, and you...
teradata compression

Teradata Compression with the DWHPRO TITHONIZER

Do you work in an environment where a compression tool is installed that works to your satisfaction? If not, I assume you are probably not...

Must Read

Popular Now

Modifying an existing table is expensive and can consume a lot of resources  (especially IOs). In this article, we will discuss the advantages and disadvantages of the two available primary strategies: ALTER TABLE and INSERT INTO...SELECT into a copy of the table. Both strategies have their individual applications and usefulness. I was creating a test...
Parallel Database Architectures
  The History of Parallel Database Architectures Parallel computing is not a new invention, being available now for more than 30 years. Parallel database architectures followed soon. Everything started with the shared memory architecture, which is still widely used this day in servers:     . The shared memory architecture is a multiprocessor system with a common...
teradata outer joins
Business intelligence tools often create queries with many outer joins. This article proves why outer joins are vulnerable to skewing. We will demonstrate that even if both tables are not skewed, it can be that the plan step by the first join step is biased. Let me carve out the details based on a simple test scenario: CREATE TABLE table1...

Social Networks

Latest Articles

This Week

teradata group by

Teradata GROUP BY Query Optimization

Teradata applies two very effective join optimization methods for decision support workload, which usually is involving a lot of aggregations: Teradata GROUP BY-  Early and Partial Aggregation Early and Partial GROUP...

The Teradata Parallel Transporter – TPT – Introduction

The Teradata Parallel Transporter - TPT Those of us who are working since many years with Teradata and its utilities know, that the Teradata Parallel...
Teradata Big Data Blocks

Advantages & Disadvantages of Teradata Big Data Blocks

Teradata Big Data Blocks - Introduction Starting with Teradata 13.10, the size of file system components (cylinders and data blocks) has been increased. In Teradata...
Subscribe to our Newsletter

Join 4500+ subscribers receiving our free newsletter.
No spam, ever. Just great stuff.

In order to activate your subscription, check your email and click on the link!

Analytics by GoSquared