Introduction to Teradata Nested Join: The Cheapest Join Method Using Indexes
Learn about the Teradata Nested Join, the cheapest join method using indexes. We explore its prerequisites, variants, and performance.
Performance Tuning
A collection of 267 issues
Understanding Teradata's SAMPLE Function: Randomly Select Rows and More
What is the Teradata Sample Function?
The SAMPLE function returns a set of randomly selected rows. Here are the characteristics:
* Ask for a sample with an absolute number of rows
* Ask for a sample that contains a certain percentage of the table rows
* Ask for more than one sample at
Efficiently Load Tables with Teradata Fast Path INSERT/SELECT: Requirements and Advantages
Fast Path INSERT/SELECT efficiently loads a single table.
Requirements for Teradata Fast Path INSERT /SELECT
* All tables involved have the same primary index.
* The target table is empty.
* Only INSERT statements can be included in the request.
How does the Fast Path INSERT/SELECT work?
This reduces access to
Hot Standby Nodes: The Secret to Seamless Performance and Recovery
A hot standby node belongs to a clique of nodes and does not host virtual processes such as AMPs or Parsing Engines.
The standby node remains idle until a member of its clique crashes or fails. At this point, the standby node is activated to take over the failed node&
Improving Row Estimates with Teradata Check Constraints
Optimizing Teradata Joins with Skewed Data: Strategies and Solutions
Skewed Teradata Joins - The Initial Situation
Consider the scenario where one table includes various currencies while the other comprises customers' accounts with their corresponding currency. Essentially, the ISO code of the currency serves as a foreign key in the account table.
CREATE TABLE Currency
(
CURRENCY_CD VARCHAR(20)
Teradata Integrated Workload Management: Features, Classification Criteria, Filters, Throttles, and Workload Priorities
Learn how Teradata Integrated Workload Management assigns workloads to queries and offers features like filters and throttles to improve system performance.
Using Sparse Maps in Teradata 16.10 for Efficient Distribution of Small Tables Across AMPs
Teradata 16.10 introduces Sparse Maps, a feature to place small table rows on one AMP. Learn more about how it can optimize your system here.
Teradata Row Size Limits: Understanding and Overcoming the 3577 Error
Learn about the Teradata row size limits and how to deal with the "3577 Row size or Sort Key size overflow" error in this informative article.