Online supplement to Teradata Query Performance Tuning - DWHPro’s Guide book
Here, we provide additional resources and real-world performance tuning case studies that did not fit the format of a book:
- A case study of tuning partition elimination, dropping execution time from 40 minutes to a few seconds.
- How the misuse of USI caused a tenfold increase in storage space.
- SQL query rewriting switched the execution plan to sliding window inclusion merge join. The execution time dropped from 35 minutes to 25 seconds.
- Templates for TPT import and export scripts.