In this article, we will give you an introduction to how Teradata can access external data stored in object stores, which formats and cloud providers are available, and how Teradata NOS differs from Teradata Querygrid Technology:What is the Teradata...

Do you have cold data that you would like to offload to make room on your Teradata system? If you want to query this data, it should still be available quickly. In this video, I show you how this can be achieved:Watch the video!

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)