Sign in Subscribe

Statistics

A collection of 51 issues

Manage and Monitor your Teradata System with Teradata Viewpoint: Features and Capabilities Explained

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

Teradata Comparison Operators and Performance: Why Choosing the Right Operator Matters

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.

How to get SQL Query Stats in Teradata

Learn how to determine SQL Query Performance in Teradata with these three essential parameters: AMPCPUTime, TotalIOCount, and SpoolUsage. Discover how to get SQL Query Stats and make the right decision for your queries using the DBC tables DBQLOGTBL and DBQLSQLTBL. Follow these three points to consi

Cloning of Tables In Teradata

Learn how to clone tables in Teradata quickly and easily using the CREATE TABLE AS statement. Transfer statistics and definitions without wasting resources.

Evaluating the Accuracy of Table Statistics: Why Collection Date May Not Be Enough

Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table's statistics with a simple query.

Optimizing Performance with Teradata Summary Statistics

Discover how Teradata summary statistics provide valuable information about the number of rows in a table, helping to optimize performance tuning.

Teradata Query Band: Optimizing Query Performance and Tracking Resource Usage

Learn what a Teradata Query Band is and how it can be used to optimize queries in a Teradata system. Discover how to set, update, and read query bands, and how to use them for performance tuning. Find out what to consider when creating a query band in Teradata.

Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command

What is the DIAGNOSTIC HELPSTATS ON FOR SESSION Command in Teradata? Gathering statistics is a crucial aspect of optimizing performance. Collecting statistics requires resources, and it matters whether they are used only once in the ETL process or cover multiple queries' workloads simultaneously. Fortunately, Teradata's recent versions

A Guide to Using Teradata TO_CHAR Function for Type Conversions and Handling Statistics

The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: * Convert numeric expressions to character strings * Convert dates, times, interval data types, or timestamps to character strings This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER,

Optimizing Teradata Joins: Tips to Reduce Resource Consumption