Understanding Teradata Express Requests and How They Work with AMPs
Learn how express requests work in Teradata, bypassing stages like syntax checking and permission checking, and how Teradata 14.10 offers a new feature to expedite them.
Administration
A collection of 61 issues
Introduction to Temporal Data Management in Teradata
Learn about Teradata's temporal data management functionality based on TSQL2 specification in this article. Discover how it simplifies historization.
Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
Throttles in Teradata Workload Management: Usage, Request and Session Limits
What are Throttles used for in Teradata Workload Management?
Throttles restrict concurrent sessions, requests, or utilities to safeguard vital resources, such as CPU, memory, and AMP worker tasks, from depletion. Their implementation in Teradata workload management minimizes contention for resources on highly concurrent systems, thus bolstering overall system performance.
Throttling
Teradata Concurrency Control: Locking and Transactions Explained
Learn how Teradata Concurrency Control uses locking and transactions to prevent simultaneous updates, deletions, or insertions in different sessions.
Teradata Utilities: Fastload, Multiload, BTEQ, and TPump
Learn about Teradata's load utilities, which can be divided into two groups: those that bypass the transient journal and those that use it. Depending on your requirements, you may choose to load data either way. This article offers advice on how and when to use each tool, including BTEQ, TPump, Fast
Teradata DATABLOCKSIZE: How to Minimize Disk I/Os and Optimize Workload Requirements
Learn how to minimize disk IOs with the Teradata DatablockSize option. Read on for an overview of how it works and how to choose the best size.
Teradata Access Rights: Implicit, Explicit, Inherited, and Automatic
Learn about the different types of access rights in Teradata, including implicit, explicit, inherited, and automatic privileges, and how they are granted to owners and creators of database objects.
Maximizing Utility Job Performance with Teradata DBQL Utility Log
To gain a comprehensive insight into the operation and performance of your load utilities and DSA jobs, the DBQLogTbl offers a starting point.
The DBQLogTbl provides metrics for these utilities, but they are not as accurate or plentiful as those provided by Teradata DBQLUtilityTbl.
What is the Teradata DBQL Utility
Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.