Teradata Partition Elimination vs. Snowflake Micro-Partitions
Dear DWHPro Subscribers! All database systems have as an important goal to minimize the number of IOs. In this article…
Read issue →SQL Tuning in the age of cloud computing
If you know Teradata, learning Redshift, Snowflake, BigQuery, etc. is ridiculously easy and the opportunity to make…
Read issue →Teradata SQL - Better performance with less code
Hi, Many times a simple rewrite of the query can achieve enormous performance improvements. In this article by…
Read issue →Colocate small tables on single AMPs
In this article, I will show you how to keep small tables in memory using your customized hash map to optimize…
Read issue →Copy tables efficiently with Teradata TPT
Hi, Are you looking for a one-line script with which you can easily copy tables between different Teradata systems or…
Read issue →Teradadata Express Edition on a Level 1 Hypervisor
Are you annoyed that Teradata Express Edition is only available for Level 2 hypervisor software (VMWare, VirtualBox)…
Read issue →Performance of SET and MULTISET tables in Teradata
Hi, In this video, we do some experiments to highlight the performance differences between SET and MULTISET tables:…
Read issue →Filter efficiently with Teradata NOS
In this article, I'll show you the most efficient way to read data from an S3 object store. The performance difference…
Read issue →