Roland Wenzlofsky
Mastering Teradata Performance Tuning
How Teradata Optimizer Uses Multi-Column Statistics
Teradata Express Edition: Converting from VMware to VirtualBox
The Teradata Express Edition is a great opportunity to experiment with a fully functional Teradata system. It can be downloaded from https://downloads.teradata.com/download/database.
Unfortunately, only VMware is supported as the virtualization software. As a user of Oracle's VirtualBox, I looked for a way to
Real-World Map-Reduce Implementations: Design and Fault Tolerance
Teradata GROUP BY vs. DISTINCT- Aggregation Methods
Learn about the differences between GROUP BY and DISTINCT for aggregations in Teradata. The optimizer now selects the appropriate algorithm depending on data demographics. Understand when to use each method to optimize query performance.
Understanding Teradata Locking: Types and Granularity
Learn about locking in Teradata to ensure data integrity and consistency. Teradata automatically selects the best lock for each situation to prevent data inconsistencies.
SQL Tuning Goals: Improving Performance and Reducing Resource Usage
Learn about the goals of SQL tuning and how to optimize database performance by reducing resource usage. Skew, IOs, and CPU seconds are key metrics. Discover how to ensure completeness and correctness of Teradata statistics, detect missing and stale statistics, and improve query plans.
Understanding Teradata DBQL Tables and Query Logging
Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to colle
Understanding Teradata Flow Control Mode for Efficient Workflow Management
Introduction
Teradata efficiently manages complex workflows by distributing and expanding processes across numerous AMPs. However, when an AMP's maximum capacity is reached, it can initiate flow control mode. This blog post delves into Teradata's Flow Control Mode, its impact on performance, and effective monitoring and management