How Teradata ORDER BY affects your query performance

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...

Read More
Sep 22, 2022
DWHPro - Tuning with TD_WhichMax

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)

Read More
Sep 19, 2022
Reduce disk IOs by 99% with this simple trick

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...

Read More
Sep 17, 2022
DWHPro - Data Modeling with the Teradata FS-LDM

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...

Read More
Sep 11, 2022
DWHPro - The Teradata MAPS Architecture

Hi,Teradata is known for being parallel at every level. AMPs ensure that queries can be processed optimally in parallel. But sometimes, it makes sense to localize the work. In this article, I will show you when to use this technique and how to apply...

Read More
Sep 10, 2022