Teradata PPI: Understanding Partitioned Primary Index for Improved Performance
Learn about the benefits of partitioned primary index (PPI) in Teradata, a method for reducing I/Os and improving performance in database systems.
Extracting Numeric Tokens from Strings with CHAR2HEXINT Function in Teradata SQL
Learn how the CHAR2HEXINT function helped solve a real-world problem of extracting number parts from a string in Teradata SQL. Read on for the solution.
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.
Improvements in Tailoring Statistics Collection with Teradata 14.00: Using Sample, MaxValueLength, and MaxIntervals Options
Learn about the latest improvements in Teradata 14.00 that allow you to customize the collection of statistics to better suit your needs. These improvements include the option to set different sample sizes, consider more bytes for histogram creation, and choose the number of intervals for building statistics histograms. Read on to discover how these changes can benefit your optimization efforts.
What is Block Level Compression (BLC) and How Does it Work for Teradata?
Block Level Compression (BLC) is a feature that allows compression of entire data blocks, leading to disk space reduction. Read on to know more.
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 Hash Index: Minimizing Disk IOs and Optimizing Rows Access
Learn about the Teradata Hash Index, designed to minimize disk IOs and improve access to rows. Discover how it differs from Single Table Join Indexes.
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.
Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
Improving Query Optimization with Teradata IPE
Learn about Teradata IPE, a technique that uses additional information collected during query execution to create execution plans in fragments.