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, Fastload, Multiload, and the Teradata Parallel Transporter (TPT). Find out which tool is most efficient for your data quantity and row size.
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 Option: How to Minimize Disk IOs 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.