Indexing
A collection of 141 issues
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,
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
Teradata Set Operators: Understanding UNION vs. UNION ALL for Peak Performance Optimization
In this article, we will delve into the world of Teradata set operators, exploring their functionality, applications for attaining peak performance, and the optimization techniques employed by Teradata.
Teradata UNION vs. UNION ALL
What sets UNION apart from UNION ALL in Teradata?
The Teradata UNION operator combines the results of
Optimizing Teradata Performance through Statistics and Primary Index Selection
1. Statistics
In Teradata, understanding and managing statistics is essential for optimizing database performance. Statistics provide the optimizer with precise data about stored information, allowing for well-informed decisions when handling queries. This article will explore the significance of statistics in Teradata, their effect on query performance, and recommended methods for
Understanding Deadlocks in Teradata: Prevention and Handling Strategies
What are Deadlocks in Teradata?
Deadlocks arise when two transactions hold locks on database objects required by the other transaction.
Here is an example of a deadlock:
Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1
Streamlining Table Cloning in Teradata and Leveraging Zero-Copy Cloning in Snowflake
Table cloning is required for purposes such as data backup, testing, and replication. Teradata, a leading data warehousing platform, provides an efficient method for cloning tables. However, Snowflake, a cloud-based data warehousing platform, offers an even more effective approach with its zero-copy cloning feature. This article will compare table cloning