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...
If you know Teradata, learning Redshift, Snowflake, BigQuery, etc. is ridiculously easy and the opportunity to make money now that the disillusionment sets in:SQL Tuning in the age of cloud computing
Hi,Many times a simple rewrite of the query can achieve enormous performance improvements. In this article by Artemios Vogiatzis, we discuss two cases revolving around duplicates and calendars:Go to the articleBest Regards,Roland - DWHPro
In this article, I will show you how to keep small tables in memory using your customized hash map to optimize performance for certain workloads.I have used this method myself in a cursor of a stored procedure to minimize the runtime of several thou...
Hi,Are you looking for a one-line script with which you can easily copy tables between different Teradata systems or databases on the same Teradata system? On our website, you can find an article that shows the details. A video also demonstrates the...
Are you annoyed that Teradata Express Edition is only available for Level 2 hypervisor software (VMWare, VirtualBox) with all the disadvantages? I'll show you how you can easily migrate Teradata Express Edition to a Level 1 hypervisor at no cost and...