Streamline Your Tasks with Teradata Macros: Reusable Blocks of SQL Code for Improved Efficiency
Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once, execute them anytime!
Track and Optimize Query Performance with Teradata DBQLOGTBL System Table
Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for all queries on the system. It is a valuable resource for tracking and analyzing query performance, as it contains information about the resources used by each query and the duration of the query. DBQLOGTBL is located in the …
Teradata Vantage now available in AWS, Microsoft Azure, and Google Cloud Storage with Teradata Native Object Store (Teradata NOS)
Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud Storage. It is worth noting that the same Teradata software runs on these three major cloud providers. This makes it relatively easy to run Teradata on-premise and in these 3 different public …
Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning Popular
BLC, Row Level Partitioning, and Datablock Size Tuning In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to influence the Teradata table size and, thus, performance. We will create a test scenario based on a customer master table loaded daily. We will …
Teradata Pro is now DWH Pro!
As always, when something comes to the attention of a larger number of people, some embrace it, some frown. We were asked to dissociate the name of this website from the term Teradata. We do so to avoid any future misunderstanding, irrespective of any admission of fault. You will find us at www.dwhpro.com from now …