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.

Teradata Viewpoint: Diagnose Slow and Waiting Queries Most read

Illustration of a person in a suit standing beside a database cylinder

What is Teradata Viewpoint? Teradata Viewpoint is a browser-based monitoring and administration interface built from portlets. For query diagnosis, its value is connecting a late report to a session, its current state and the evidence needed for the next investigation. Available systems, portlets and actions depend on your installation and assigned roles. Worked example: investigate …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam