Architecture
A collection of 111 issues
Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance
Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.
Teradata Query Parallelism
A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data.
Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high
Understanding Partial Group By: Reducing Join Costs with Aggregation Optimization
Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries
Improve the Performance of your Teradata System
Executing the following query may reveal that a small number of queries are responsible for consuming a significant portion of the resources in the Teradata System. Improving the performance of these queries can greatly impact the system's overall health.
Your Teradata
Teradata Priority Scheduler and Resource Allocation Rules
Learn about Teradata's priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
How to Find ASCII Code of a Character Using Teradata SQL
How to Improve Cardinality Estimations in Teradata: The Optimizer's Toolkit
Learn about Teradata Heuristics and Optimizer's approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.
Is Teradata Compression Worth Your Time and Effort?
Teradata DBMS offers various compression options to save disk space and improve performance. But, the cost of implementing the compression takes man-time. This article discusses the cost vs. benefit of compression and suggests carefully considering the compression setting when designing new or modif