SQL Tuning Goals: Improving Performance and Reducing Resource Usage

What are the Goals of SQL Tuning? Resource consumption must be minimized to optimize a database system, and three crucial ...

Read More
SQL Tuning Goals: Improving Performance and Reducing Resource Usage

Teradata SQL Tuning: How Query Rewriting Can Reduce Runtime from 40 Minutes to Seconds

It’s time to share a new Teradata SQL tuning case study that showcases the impressive impact of query rewriting on ...

Read More
Teradata SQL Tuning: How Query Rewriting Can Reduce Runtime from 40 Minutes to Seconds

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 ...

Read More
How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study

Teradata Statistics Extrapolation: What it is and How it Works

What is Teradata Statistics Extrapolation? In data warehousing, populating historized tables with snapshot data valid for the current day is ...

Read More
Teradata Statistics Extrapolation: What it is and How it Works

“Boosting Teradata Statistics Performance with New Syntax in Release 14.00”

Release 14.00 introduces significant enhancements for Teradata statistics, which merit a detailed explanation. Familiarizing yourself with the new syntax is ...

Read More
“Boosting Teradata Statistics Performance with New Syntax in Release 14.00”