Indexing
A collection of 141 issues
Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods
Teradata employs various join methods and techniques to merge the rows of two tables onto a single AMP, which is essential for joining. The combination of join technique and data geography is called the join strategy, and its goal is to reduce resource consumption (CPU seconds, I/Os). Some join
Teradata MERGE INTO vs. UPDATE: Performance Comparison and Limitations
Teradata Antiselect: Selecting All Columns Except the Ones You Exclude
Teradata has incorporated several analytical functions from Teradata Aster in its recent releases. Although many of these functions are tailored for web click analysis, Teradata Antiselect has proven valuable for specific applications.
What is the Teradata Antiselect function?
Teradata's Antiselect function allows for the reversal of column selection
Teradata Table Skew: Understanding Natural and Artificial Skew with DBC.TableSizeV
Teradata table skew is a common issue encountered while working with the Teradata database. If you're reading this page, you may have experienced this problem.
Common knowledge
When searching for Teradata table skew or skew factor online, most or all documentation will refer directly to DBC.TableSizeV for
How Join Indexes Can Optimize Performance in a Normalized Data Model
Save Space with Teradata: Utilizing Block Level Compression and Row Partitioning
Teradata Tactical Workload
Loading Data into Teradata using Python and Fastload
This article assumes prior basic knowledge of Python and demonstrates the easy process of loading data using Python and the Teradata SQL Driver for Python with Fastload.
If you are using Windows, we recommend using WinPython if you don't have Python installed yet. Because a Jupyter Notebook is
Tracking Teradata Statistics Usage with StatUseCountV
How to find out if the Teradata Statistics we created for a specific workload are used?
Teradata statistics greatly affect SQL query efficiency.
We need a reliable method to get this information.
Various objects, such as tables and join indexes, can have statistics collected on them. As performance tuners, it