Has it ever happened to you that you issued an UPDATE statement on a huge table, and your statement took forever to run? A rollback paralyzed the entire system for hours when you finally aborted your UPDATE. In this article, I will show you how to pr...

Hello, valued reader of the DWHPro Newsletter,In this article, you'll learn how Teradata is truly parallel at every level. Even sorting the result set is perfectly tailored to the shared-nothing architecture:Watch VideoHave a nice day,Roland - DWHPro

Hi,In this video from DWHPro, you will learn all about Teradata Spool Space. How to optimally set up spool space on your Teradata system, how to find ways to create space on a system with space problems and which common mistakes you should avoid to p...

This video discusses the memory hierarchy of a modern computer system and how it affects Teradata performance, and the methods Teradata uses to increase it:The Teradata Memory HierarchyHave a nice weekend,RolandIf you shop at Amazon India and are int...

Hi, valued reader of the DWHPro Newsletter,The optimizer has various access paths when creating the execution plan. Each of these access paths has certain advantages and disadvantages:8 Teradata Access Paths You Should KnowFor all our newsletter read...

Hi, valued reader of the DWHPro newsletter,Learn the 10 best and proven tricks to make your SQL queries faster and more efficient.10 tricks to master Teradata SQL tuningJoin our Telegram GroupBest Regards,Roland - DWHPro

Hello, valued reader of the DWHPro Newsletter,In this article, you'll learn how Teradata is truly parallel at every level. Even sorting the result set is perfectly tailored to the shared-nothing architecture:How Teradata ORDER BY affects your query p...

Hey there, In our latest article, we will show you how to optimize the performance of your queries by using the functions TD_WhatMax and TD_WhatMin:Tuning with the Teradata TD_WhichMax FunctionCheck out our Teradata Book (Amazon)

Hey, there!Often we can achieve great tuning success by decoding the problem and then rewriting the queries. This can, of course, be more costly than a purely technical optimization in which we consider the problem as a black box, but can be ver...

Hi,In this article, we will teach you the following:What is A Data Model?What are the Major Types of Data Models?What is the FS-LDM?How is the FS-LDM Implemented?Go to the article: Data Modeling with the Teradata FSLDM.Anyone involved with the Terada...