Sign in Subscribe

Performance Tuning

A collection of 267 issues

Collect Statistics in Teradata - Evaluation

Collect Statistics in Teradata - The Evaluation After collecting every combination considered necessary and helpful, you can check the result of the collected statistics on a table by looking at * the time it took to collect and the then prevailing circumstances * the collection results Consider the lengthier collection time when

Teradata Join Strategies: How to Optimize Join Operations

Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. The paired table rows must reside on identical AMPs. The chosen method for joining and relocating data is called a join strategy. The preparation for each join method varies. The choice of Teradata join strategy utilized by

Mastering Teradata Performance Tuning

The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are essential, occasionally accompanied by fortuitous circumstances. I'll demonstrate the remarkable outcomes that can be attained by rephrasing a query using this example. Assuming this scenario: Want more practical data engineering analysis like

How Teradata Optimizer Uses Multi-Column Statistics

A recent question came in about how the Teradata Optimizer uses multi-column statistics. Here are the essential details: The Optimizer uses multi-column statistics when the query's WHERE clause covers all columns. Want more practical data engineering analysis like this? Join DWHPro Letters and get field-tested notes on Teradata,

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

Here is an illustration depicting the design of real-world map-reduce implementations, such as Hadoop: The input files reside in a distributed file system, such as HDFS for Hadoop, or GFS as Google calls it. Worker processes handle mapper or reducer tasks. Want more practical data engineering analysis like this? Join

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.

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