Detecting Overlapping Time Periods with Teradata OVERLAPS Command: A Simple Syntax Guide
Learn how to use the Teradata OVERLAPS command to detect overlapping time periods with this example query. Caution: minimum overlap required.
AI & Data Engineering
A collection of 53 issues
Teradata Columnar Compression Methods: Run-Length, Dictionary, and Delta Compression
Learn about the benefits of compression in Teradata Columnar, including a reduction in permanent space and disk IOs. Different compression methods are used, including run-length, dictionary, and delta compression. This article explains how each method works and the advantages of using them.
Teradata ALTER Table vs. INSERT INTO: Which Method is Efficient?
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
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
Benefits of Organizing Stored Procedures into Chapters and Steps
Teradata Locking Logger: How to Enable and Analyze Lock Activity
Teradata 16 Introduces New Features for UNION ALL Queries
Teradata UNION ALL - The New Features of Release 16
Teradata 16 introduces new features for UNION ALL queries that can enhance their performance, although their application is not guaranteed.
The Optimizer will opt for executing the query through conventional methods if the cost estimations for the traditional execution plan
Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution
Get a Grip on Clumpy Row Distribution - the Teradata PPI Table.
For this technique to work properly, the primary index in Teradata should not include the partition column(s).
We have all encountered the issue of slow table inserts, where the distribution of rows across all AMPs is even,