Teradata DBQLOGTBL is a system table in the Teradata database management system that stores log data for all queries on ...

Teradata DBQLOGTBL

Teradata Spool Space Introduction What is Teradata Spool Space?Teradata Spool Space is a workspace that Teradata uses to store temporary ...

No more Teradata Spool Space Problems

BLC, Row Level Partitioning, and Datablock Size TuningIn this article, we will learn how block-level compression, row-level partitioning, and selection ...

Teradata Table Size Optimization Techniques

If you are looking to have in-depth knowledge of how your load utilities (or even DSA jobs) are running in ...

Get In-Depth Knowledge of how your Loading Utilities perform using the Teradata DBQL Utility Log

What is Query Logging with Teradata DBQL Tables? Query Logging is a feature that allows us to analyze workload and ...

Master performance with Teradata DBQL

What is a Teradata Query Band? The DBQL tables provide us with all the key figures we need to optimize ...

The Teradata Query Band and Performance Tuning

What are Teradata roles? Roles serve to simplify rights management. A user assigned a role automatically has the same rights ...

Teradata roles and their proper use

What is a Teradata Rollback? A rollback reverses an incomplete transaction. Transactions can be unfinished for various reasons, such as ...

Teradata Rollback – Abort as an Emergency Solution

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, ...

Teradata Compression with the DWHPRO TITHONIZER

A hot standby node is a member of a group of nodes (clique), and no virtual processes are running on ...

Teradata Hot Standby Node Explained