Sign in Subscribe

Performance Tuning

A collection of 267 issues

Maximizing Performance with Multiple Teradata Sessions

Teradata Sessions explained in a few Sentences What is a Teradata session?A session is a LOGON of a user on a Teradata system through which one or more sequential transactions can be executed. A LOGOFF statement terminates the session. What are multiple Teradata sessions (e.g., in BTEQ)?For

Two Methods for Generating Number Ranges in Teradata

Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata: WITH RECURSIVE NumberRanges(TheNumber,TheString) AS ( SELECT 1 AS TheNumber,casT(1 as VARCHAR(500)) as TheString FROM ( SELECT * FROM (SELECT NULL AS X) X ) DUMMYTABLE UNION ALL SELECT TheNumber + 1 AS TheNumber,

Understanding Partial Group By: Reducing Join Costs with Aggregation Optimization

Why Teradata's LIKE operator behaves differently for CHAR and VARCHAR columns

Have you observed the different behavior of the Teradata LIKE operator when applied to a CHAR or VARCHAR data type column? Consider the following table as an illustration: Creating a table: CREATE TABLE TheLikeTest ( TheVarchar VARCHAR(20), TheChar CHAR(20) ); To illustrate, we will add a single row. Want more

Advanced GROUPING Methods in Teradata SQL: GROUP BY GROUPING SETS, ROLLUP, and CUBE

Teradata SQL and Advanced GROUPING Functions What advanced GROUPING methods are there in Teradata SQL?- GROUP BY GROUPING SETS - GROUP BY ROLLUP - GROUP BY CUBE What is GROUP BY CUBE used for?One or more columns are used to group across multiple dimensions. If grouped by n

Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries

Warning: Teradata 16.20 Upgrade May Affect Reporting Queries - Potential Fix Found

Achieve Incredible Teradata Join Performance

Become a Teradata Vantage Expert with Our Free Android App: Download Now from Google Play Store!

Teradata Multivalue Compression and Presence Bytes for NULL Values

Multivalue compression and null indication serve distinct purposes yet share a common objective of storing information about the values of each row's columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability. Readers familiar with earlier releases will recognize that the name