Performance Tuning
A collection of 267 issues
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
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
Improve the Performance of your Teradata System
Executing the following query may reveal that a small number of queries are responsible for consuming a significant portion of the resources in the Teradata System. Improving the performance of these queries can greatly impact the system's overall health.
Your Teradata
Warning: Teradata 16.20 Upgrade May Affect Reporting Queries - Potential Fix Found
Achieve Incredible Teradata Join Performance
Executive summaryGUEST POST BY ARTEMIY KOZYR
Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues.
You will learn
Become a Teradata Vantage Expert with Our Free Android App: Download Now from Google Play Store!
Become a Teradata Vantage expert by downloading our new Android app for free from the Google Play store and practicing.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on Teradata, Snowflake, AI, migrations, performance, and enterprise data work. Early subscribers keep launch access
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