Hi,Boost your Teradata query performance with our innovative solution that optimizes resource-intensive LIKE operators! Creating an auxiliary table with a specific subset of columns can efficiently join the wide table and avoid the dreaded full table...

Hello, I hope this email finds you well! We are excited to announce that DWHPRO is launching a new, free online course: Teradata Performance Tuning. We have designed this course to help you master the art of optimizing your Teradata system for peak p...

Hi there,Learn about the hidden problem of hash collisions in Teradata Primary Index using CHARACTER columns with millions of distinct values! Our in-depth article reveals a test scenario that highlights the impact of hash collisions on performance a...

Hello,Are you looking to optimize your Teradata database system and achieve peak performance? Look no further! We have compiled a comprehensive guide covering everything from managing statistics to query optimization.In this guide, you'll discover:Th...

Hi!Discover how Teradata efficiently locates table rows in our latest article! Learn about the various components involved in the row retrieval process, such as hash maps, master indexes, cylinder indexes, and search algorithms like binary and sequen...

Hi,In this article, I will show you how to optimize your DML statements by bypassing the Transient Journal:Read the ArticleBest Regards,Roland - DWHPro

Hi,In this article, we compare the performance of an UPDATE statement with a MERGE INTO statement:Read the Article...Best regards,Roland - DWHPro

Hi,Teradata NOS allows us to query data stored in an S3 object store easily. To achieve optimal performance, it is important to partition the external data so that it can be read as efficiently as possible. In this article, I will show you what you m...

Hi,What is phantom spool? What is leftover spool?In this article you will learn everything about Teradata spoolspace:All about Teradata SpoolspaceBest Regards,Roland - DWHPro

Dear DWHPro Subscribers!All database systems have as an important goal to minimize the number of IOs. In this article we compare Snowflake and Teradata and how both systems achieve this goal:Teradata Partition Elimination vs. Snowflake Micro-Partitio...