DWHPro Insights

SQL Tuning

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Teradata Explain Statement: A Guide to Optimizing SQL Performance Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

What is the Teradata Explain Statement? Optimizing performance can be challenging, often requiring significant effort to identify the root issues. Thankfully, Teradata provides the EXPLAIN statement as a robust tool for assessing the execution of SQL statements. In Teradata, SQL statements are processed in a series of distinct tasks that correspond to specific components of …

Read more

Teradata Temporary Tables: A Guide to Derived and Volatile Tables Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

Introduction to Teradata Temporary Tables This article highlights the distinct types and uses of Teradata temporary tables. 1. Derived Tables To avoid syntax errors, tables derived from queries should always be given an alias. Here is a derived table example (in parentheses): Create temporary-table DDL before beginning the BTET data transaction; do not mix the …

Read more

A Guide to Using Teradata TO_CHAR Function for Type Conversions and Handling Statistics Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT/REAL/DOUBLE PRECISION, or NUMBER. The format string, which must be of type CHAR or VARCHAR, represents the second argument (Further information on …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam