Sign up for the free newsletter. Only subscribers will receive exclusive free offers such as useful queries, stored procedures, and tools.



The Teradata Forum

Discuss with other Teradata experts in our new forum

Typically, reporting scenarios require to aggregate one ore several facts of a certain reporting date or a range of dates. If the involved tables are historized with start date and end date, the frequently seen join scenario is that the driving table is product joined with a calendar table and restricted on the reporting date, such as in our example below: SELECT...
Introduction In today’s business, it is critical to respond as fast as possible to opportunities and problems as they happen. These business events can be detected and collected for immediate processing resulting in an alert to a front-line user or an update message to an operational system. Teradata parallel database triggers manage exactly this kind of live events. Typically, every X minutes, a...

Weekly Report

Fresh Articles

Teradata Volatile Tables – The Characteristics

These are the main characteristics of Teradata Volatile Tables: Teradata Volatile Tables only exist in the creating session (for example, a session in the SQL Assistant). Whenever...

The Costs of Decomposable Columns

What are Decomposable Columns? Decomposable columns can be split into smaller units. Decomposable columns mean that the physical data model is not normalized. If we don't...

Must Read

Popular Now

Updated 2015-07-07Teradata Comparison Operators and Performance are interrelated to some extent. Choosing the proper comparison operator can make the difference between a well performing and a poor performing query. But why should the selected comparison operators have an impact on performance? Statistics are the most important input to the Teradata Optimizer, and they...
  The Technical Details of the Non-Unique Secondary Index in Teradata - NUSI Many concepts of Teradata indexing are tightly coupled to the physical storage of data rows. Therefore, I highly recommended reading our article series about physical storage: https://www.dwhpro.com/teradata-physical-storage/ The Teradata Non-Unique Secondary Index (NUSI) is an alternative data access path...
There are several ways of writing SQL statements and making use of transaction handling. Each method has its own advantages, disadvantages, and behavior which you have to consider. As an example let's consider two statements which have to be executed in sequence: (1) DELETE FROM TestTable; (2) INSERT INTO TestTable SELECT *...

Social Networks

Latest Articles

This Week

Teradata Compression Considerations

When Teradata compression becomes pressing Have you ever seen your data warehouse approaching space limits or some of your tables’ Current Perm skyrocketing as you...

Teradata Comparison Operators and Performance

Updated 2015-07-07Teradata Comparison Operators and Performance are interrelated to some extent. Choosing the proper comparison operator can make the difference between a well performing and...

Using the Teradata Queryband

Typically, reporting scenarios require to aggregate one ore several facts of a certain reporting date or a range of dates. If the involved tables are historized...
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!

x