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