Mastering Teradata Recursive Queries: How to Create and Use Them for Shortest Path Problems

Teradata Recursive Queries SQL provides two options for constructing a Teradata recursive query: utilizing the WITH RECURSIVE clause within a ...

Read More
Mastering Teradata Recursive Queries: How to Create and Use Them for Shortest Path Problems

5 Tips for Optimizing Teradata SQL Queries: Avoiding Joins, Functions, Union, and Group By

Is Teradata-Specific SQL different from SQL? While the SQL Teradata uses is a dialect of SQL, there are some differences ...

Read More
5 Tips for Optimizing Teradata SQL Queries: Avoiding Joins, Functions, Union, and Group By

Teradata Show Table Proxy: Recreate Full DDL from DBC Tables and Views

A Teradata Show Table Proxy for Full DDL Recreation from DBC Throughout my recent development activities, an old desire became ...

Read More
Teradata Show Table Proxy: Recreate Full DDL from DBC Tables and Views

Distinct vs. Group By Understanding Performance Differences Based on Data Demographics in Teradata

Previously, numerous debates have emerged concerning the superior performance of specific statements: SELECT <COLUMN> GROUP BY 1 or SELECT DISTINCT ...

Read More
Distinct vs. Group By Understanding Performance Differences Based on Data Demographics in Teradata

Teradata Historisation – Daily snapshot to change history

For various reasons, we may need to switch our Teradata historisation from snapshot tables to a start date/end date logic ...

Read More
Teradata Historisation – Daily snapshot to change history