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 case study demonstrates how the Optimizer …