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...
What is the Teradata TD_WhichMax Function? Teradata releases new SQL features with each update, providing enhanced functionality and improved performance with reduced resource usage. We will examine the Teradata TD_WhichMax and TD_WhichMin functions...
This article will show a case study from my past projects. It is an implementation in which, from a row per primary key that contains a start date and an end date, rows are to be generated for all days in between. I have simplified the query for demo...