Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.
Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.
Learn about the features and benefits of Teradata Identity Columns, and why they are used for transactional and bulk inserts. Discover the data types, syntax, and more.
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.
Learn about tactical workload tuning in Teradata, which requires unique skills and tools. This article covers the skills needed to optimize tactical queries and highlights the difference between tactical and decision support workloads. Discover the Tactical Workload Toolkit and how to use join indexes for optimization.
Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.
Teradata Active System Management (TASM) offers dynamic workload management features that allow workload adaptation based on system conditions. Learn more here.
Learn how to optimize SQL queries in Teradata with this case study. See how a recursive query was replaced with a more efficient approach.
Teradata Viewpoint is a web-based tool for monitoring and managing Teradata data warehousing systems. This article explores the tool’s functionalities and how to utilize it for monitoring and managing your Teradata system. What is Teradata Viewpoint? Teradata Viewpoint is a web-based tool that provides a single access point for monitoring and managing Teradata systems. It …
Learn how Teradata Comparison Operators and Performance are linked, and how choosing the right operator can impact query performance. Column statistics play a crucial role in the Teradata Optimizer, and this article explores how to use them effectively.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Miami, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.