The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and achieve the same result. While the answer is the same, Teradata may use a completely different execution plan ba...
Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once, execute them anytime!
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...
Teradata Querygrid is a feature of the Teradata database management system that allows users to access data from multiple data sources and perform distributed queries across those sources. In this article, we will explore the concept of Teradata Quer...
Teradata Viewpoint is a web-based tool that allows users to monitor and manage their Teradata data warehousing systems. In this article, we will investigate the features and capabilities of Teradata Viewpoint and how to use it to monitor and manage y...
In this article, I show you how to migrate the VMWare image of Teradata Express Edition on a Level 1 hypervisor. Teradata offers the Express Edition for various Level 2 hypervisors (VirtualBox, VMWare, UTM, etc.) for download, but this is not the sam...
Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning external data is crucial for efficient reading. This article outlines the key considerations for optimal efficiency when reading data...
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 mak...
What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in T...