Teradata OLAP Functions: A Systematic Approach to Understanding Window Aggregates
Learn how to work with Teradata OLAP Functions in your data warehouse applications. This systematic approach covers five key design decisions.
Optimal Performance by Avoiding CHARACTER Columns in the Primary Index
The Teradata Primary Index and Hash Collisions Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be minimal performance losses, but this …
Teradata Statistics Maintenance: Milestones, Aging and Recollection, Collection Statement Register, and Triggered Partial Recollection Specification
Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.
Optimizing Workload with Teradata’s Sample Statistics Feature
Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.
Teradata Identity Columns: Features, Benefits, and Syntax
Learn about the features and benefits of Teradata Identity Columns, and why they are used for transactional and bulk inserts. Discover the data types, syntax, and more.
Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.
Optimizing the Tactical Workload in Teradata: Skills and Tools Needed
Learn about tactical workload tuning in Teradata, which requires unique skills and tools. This article covers the skills needed to optimize tactical queries and highlights the difference between tactical and decision support workloads. Discover the Tactical Workload Toolkit and how to use join indexes for optimization.
The Vulnerability of Outer Joins in Business Intelligence Tools: A Simple Test Scenario
Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.
Teradata Dynamic Workload Management Features: What You Need to Know
Teradata Active System Management (TASM) offers dynamic workload management features that allow workload adaptation based on system conditions. Learn more here.
Optimizing Teradata Queries: A Case Study on Generating Rows Between Start and End Dates
Learn how to optimize SQL queries in Teradata with this case study. See how a recursive query was replaced with a more efficient approach.