DWHPro Insights

Statistics

Teradata Heuristics for Nonindexed Columns Popular

Illustration of a stopwatch dial on an orange paint-splash background

Learn about heuristics in Teradata optimizer and how they estimate the number of selected data rows for nonindexed columns in WHERE condition predicates. This post analyzes several queries and their estimates based on heuristics and provides insights on how to replace heuristic estimations with more accurate ones.

How to get SQL Query Stats in Teradata Popular

Illustration of a stopwatch dial on an orange paint-splash background

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 consider while running the query and get accurate results.

Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command Widely read

Illustration of a stopwatch dial on an orange paint-splash background

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 can be configured so that the “COLLECT STATISTIC” …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam