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?
Teradata ALTER Table versus INSERT INTO
Altering the structure of a substantial Teradata table can consume significant resources. Essentially, there are two approaches: altering the DDL through Teradata ALTER TABLE or generating an empty table with the desired DDL statement and transferring data via the Teradata INSERT INTO statement. Each
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
I made organizing Stored Procedures into Chapters and Steps a principle.
These separation points are marked by comments and variables used in performance and result logging.
A step refers to a technical or conceptual task that cannot be further divided without losing the abstraction of Stored Procedures or the main
Teradata Locking Logger: How to Enable and Analyze Lock Activity
Turning on the Teradata Locking Logger
by Vasudeva Rao
To activate the locking logger, access the DBS console window or cnsterm subsystem and ensure it is enabled. Note that the change will only take effect once the database has been restarted. Below is the dbscontrol help output for the flag
Teradata 16 Introduces New Features for UNION ALL Queries
Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution
Teradata Physical Storage: Understanding the Technical Details for Performance Optimization
A thorough understanding of the Teradata system's technical intricacies is crucial to attaining expertise in performance optimization. Although many of us are knowledgeable about existing optimization opportunities, resolving complex performance issues often requires an in-depth understanding of internal data storage.
Until recently, data storage relied solely on hard