Track and Optimize Query Performance with Teradata DBQLOGTBL System Table Popular

Illustration of a person in a suit standing beside a database cylinder

Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for requests captured by configured DBQL rules. 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 …

Read more

Teradata Native Object Store on AWS, Microsoft Azure, and Google Cloud Popular

Illustration of three stacked database units of differing heights inside a circle

Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud. 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 clouds …

Read more

Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning Popular

Illustration of a stopwatch dial on an orange paint-splash background

BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. 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 …

Read more

Teradata Pro is now DWH Pro!

teradata volatile table

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 …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam