It is time to publish another case study about Teradata SQL tuning,  which impressively demonstrates the terrific impact of query rewriting on performance. Our object of study is the query below, which initially ran about 40 minutes. As usual, I added all missing statistics and ensured that no statistic is stale: Something a SQL tuning specialist

Read More

Teradata IPE Traditionally, Teradata creates execution plans based on the information available at query optimization time. The information mainly used are statistics and cost factors, such as the type of used storage devices, CPU models, available main memory, etc. The optimizer creates several execution plans and chooses the one with the least costs. Incremental Planning and

Read More

What is the Teradata Explain Statement? If you are new to Teradata, performance optimization of a single SQL statement can be quite challenging, and you may not know where to begin. Luckily, we have a handy tool that gives us valuable information for performing this task: The Teradata EXPLAIN statement. By combining the use of

Read More