Understanding Soft Referential Integrity and Its Role in Improving Performance
Learn about referential integrity and how it ensures data consistency in databases. Discover soft referential integrity and its use in inner join elimination.
Query Optimization
A collection of 72 issues
How to Optimize Joins in Teradata: A Case Study
Learn how to optimize joins in Teradata with this case study. Discover how simple changes in query text can improve query performance.
How to Use Biased Value Histograms for Accurate Statistics Estimation on Teradata SQL
Learn how biased value histograms store exact cardinalities and provide up-to-date statistics for queries, and witness how the Optimizer estimates the number of rows for a given query.
Improving Performance through Query Rewriting with Row Partition Elimination: A Real-World Optimization Example on a 400-Million-Row Table
Learn how query rewriting can improve performance in row partition elimination. Follow the test setup to optimize the retrieval of rows from a table.
How to Reduce Skew in Teradata Joins Using the RANDOM() Function
Teradata Tuning Ideas: Best Practices and Strategies
Learn how to optimize Teradata performance with these general tuning ideas. From changing one parameter at a time to testing on the target system.
Practical Approach for Teradata SQL Tuning: Finding the Root Cause of Performance Issues
Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
Improving Query Optimization with Teradata IPE
Learn about Teradata IPE, a technique that uses additional information collected during query execution to create execution plans in fragments.
Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.