Hi,In this video, we do some experiments to highlight the performance differences between SET and MULTISET tables:Watch the video!Roland - DWHPro
In this article, I'll show you the most efficient way to read data from an S3 object store. The performance difference when not filtering correctly can be enormous: Filter efficiently with Teradata NOSGoto Youtube Channel
With NOS, Teradata Vantage offers an easy way to offload cold data to cheap S3 object stores (AWS S3, Azure Blob, Google Storage) and still have it available online. I show you in this video how it works: Watch the video!
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...