Teradata Utility Workload Management: Overview and Protocols
Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.
Administration
A collection of 61 issues
Understanding Teradata Workload: Definition, Advantages, and Characteristics
Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.
Global Teradata System Characteristics Database: Help Us Build It!
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
Without Teradata CHECK Constraint
When a non-indexed column is utilized in a retrieval operation (i.e. WHERE statement) and lacks Teradata Check Constraints, the Optimizer employs heuristics to approximate the number of rows in the resulting set by inferring missing statistics.
The estimated number of rows is 7,342, equivalent
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.
Improving Performance through Query Rewriting with Row Partition Elimination: A Real-World Optimization Example on a 400-Million-Row Table
Learn how query rewriting can improve performance in row partition elimination. Follow the test setup to optimize the retrieval of rows from a table.
Understanding Workload Flow Control with DBC. ResUsageSAWT Table in Teradata 14.10 and Later Versions
Learn how to analyze workload in Teradata using the DBC.ResUsageSAWT table. This guide explores the essential columns and measures to consider.