Implementing Teradata Compression: A Guide to Managing Data Warehouse Capacity and Saving Space
Learn how to use compression as a table column addition to manage your data warehouse's space effectively. Discover constraints and best practices.
Utilities & Loading
A collection of 89 issues
Efficiently Load Tables with Teradata Fast Path INSERT/SELECT: Requirements and Advantages
Fast Path INSERT/SELECT efficiently loads a single table.
Requirements for Teradata Fast Path INSERT /SELECT
* All tables involved have the same primary index.
* The target table is empty.
* Only INSERT statements can be included in the request.
How does the Fast Path INSERT/SELECT work?
This reduces access to
Teradata Integrated Workload Management: Features, Classification Criteria, Filters, Throttles, and Workload Priorities
Learn how Teradata Integrated Workload Management assigns workloads to queries and offers features like filters and throttles to improve system performance.
Variable Declarations in Teradata Stored Procedures
Learn how variable declarations work in a Teradata Stored Procedure. Declarations are always local to the surrounding compound statement. See examples.
Teradata SQL Tuning: Minimizing Costs and Maximizing Parallelism
Learn how to optimize SQL tuning on Teradata by minimizing I/Os and maximizing parallelism, which can be achieved by evenly distributing rows across all AMPs.
Static and Dynamic SQL Characteristics: Examples and Differences
Learn about the characteristics of static and dynamic SQL in Teradata stored procedures. Discover how to use variables and parameters in SQL statements.
Teradata SQL Stored Procedures: Adding Procedural Functionality to Your RDBMS
Teradata SQL Stored Procedures enhance traditional SQL with procedural language features like iterations, condition and error handling, and variables. Learn more here.
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
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