Introduction to Temporal Data Management in Teradata Widely read
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 Popular
Explore SAMPLE, MAXVALUELENGTH and MAXINTERVALS statistics options introduced in Teradata 14.00. Check valid settings and saved options for the current release.
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 Row 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 tune Teradata queries by measuring I/O, CPU and execution skew. Even row distribution helps, but does not guarantee equal work across AMPs.
Decomposable Columns: Definition, Impact on Performance, and Workarounds Popular
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.
The Importance of PDM in Database Compression and Resource Usage Optimization
The importance of the PDM Compression is a widely used method for reducing IOs by enabling the accommodation of more rows in each data block. Data blocks are the smallest unit exchanged between hard drives and main memory, which is the most costly operation in any database system. Compression can be automated through block-level compression …
Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
Improving Teradata Performance with SQL Query Rewriting
Learn how to improve the performance of SQL statements by rewriting them through this article on Teradata tuning. Follow along as we analyze a high-runtime SQL statement and optimize it to significantly reduce disk I/O and spool space usage.