Understanding Teradata Value Ordering for Improved Range Scans and Data Retrieval
Learn about Teradata value ordering, an optimization technique for range scans of 32-bit integers. Read on to understand how it is implemented.
Performance Tuning
A collection of 267 issues
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 Partitioning: Row vs. Column for Efficient Data Access
Learn about Teradata Partitioning and how row and column partitioning can minimize data access resource usage. Read on for benefits and examples.
How to Avoid Full Table Scans When Using LIKE Operators in Teradata Indexing
Learn how to avoid resource-killing full table scans on extensive tables with Teradata Indexing. Discover a fantastic trick to optimize query performance.
Boosting Teradata Statistics Performance with New Syntax in Release 14.00
Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.
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.
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 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).