Query Optimization
A collection of 72 issues
Optimizing Queries with LIKE Operator in Teradata
Learn how to optimize LIKE operator queries in Teradata to avoid full table scans and improve performance. Read on for expert tips and tricks.
Teradata: Unleashing the Potential of a Powerful Data Warehouse Solution
Introduction
Discover the world of Teradata, an industry-leading data warehouse and analytics platform that offers unparalleled performance, scalability, and ease of use. This comprehensive blog post will explore Teradata's key features and benefits, learn about its architecture, and discuss its significance in modern data-driven organizations.
Stay tuned as
Optimizing Teradata Joins: Handling Skewed Workloads with Partial Redistribution and Partial Duplication
How does Teradata handle Skew in Joins?
The imbalanced workload is a primary issue that must be addressed in performance optimization.
Efficient optimization is crucial for join steps due to the possibility of Teradata transferring significant data volumes between AMPs.
The optimizer can perform joins separately for primary index values
Choosing the Right Teradata Data Types
Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations
Teradata Table Design Checklist
As creating tables is a frequent task, I deemed it necessary to provide a checklist.
* Primary Index or NOPI?
* Is the Primary Index distributing rows evenly?
* Is the correct character set used?
* Are character sets and data types matching across tables?
* Can the Primary Index be
How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study
The Optimizer typically excels in utilizing statistics, yet examining the execution plan and cardinality estimations can sometimes be beneficial.
Since Teradata 14.10, I have habitually included the SHOW STATISTICS statement in my considerations. The resulting metrics can aid in identifying statistical issues.
Teradata Statistics - Avoid the Heuristics
This
Optimizing Teradata Requests with Group-AMP Operations for Improved Performance
Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management
Learn why you should opt for DELETE instead of DROP when it comes to Teradata DDL. Avoid locking dictionary tables and conserve resources.
Teradata Statistics: Understanding and Using Collected Metrics for Optimal Query Performance
Discover the importance of Teradata statistics in optimizing query execution plans. Learn how to collect statistics and when to use them for best results.