Understanding MaxValueLength and Its Importance in Teradata Statistics
Learn about Teradata's MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
Teradata
A collection of 307 issues
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
Improve Performance with Teradata Partition Elimination: The Stored Procedure Approach
Learn how to solve the problem of accessing a table containing many rows using Teradata Partition Elimination with a Stored Procedure.
Understanding Teradata Nodes in Parallel Systems: Architecture and Scalability
Learn about Teradata Nodes - Linux systems packed into cabinets with multicore CPUs, memory, and parallel database extension software (PDE).
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.
Effective Teradata Performance Optimization: A Guide to Measuring Improvements
Optimizing Teradata performance can be time-consuming and unpredictable. Before starting, it's crucial to define clear goals and measure improvements using absolute criteria like CPU usage and disk access. In this article, we'll explore the areas that can be optimized in a typical Teradata Data Ware
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.
Understanding the Teradata Primary Index: Distribution, Hashing Algorithm, and Performance Considerations
Learn about the Teradata Primary Index, which distributes table rows across all AMPs for parallel execution. Discover how to select the best index for performance and avoid hash collisions.
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