Article by Mitchell Craig, William Darling The Viewpoint Dashboard (released with Viewpoint 15.11) is designed to give you an at-a-glance overview …
Category: Performance Tuning
-
-
Teradata XML Data Type
Teradata XML The XML Data type, introduced in Teradata 14.10, provides the following new capabilities: •A new XML data type that allows …
-
New StatsInfo query for TD14 / 15
Article by : Dieter Noth Beginning with TD14 statistics are no longer stored in dbc.TVFields and dbc.Indexes, they have been …
-
PRPD – Partial Redistribution Partial Duplication
Teradata V14.10 Join Feature PRPD Rows being joined must be on the same AMP, so Teradata will redistribute one or both tables by the join …
-
Teradata Explain
When developing queries, always perform Teradata Explain on the query before you run it.Explains can give a lot of information the …
-
STATS Process – Daily / Weekly / Monthly
Knowledge/Statistics has power. It controls access to opportunity and advancement.
-
Skewness Unleashed !!
SKEWNESS – IN A NUTSHELL Teradata is a massive parallel system, where uniform units (AMPs) do the same tasks on …
-
Query to identify jobs which went to penalty box during its execution
Penalty Box A Penalty box is more of a workload management strategy than Viewpoint (although you configure workload management with …
-
Real Time Performance tuning examples !!
Performance tuning Performance Tuning #1 Recently we encountered an issue wherein a query was running with high impact CPU/IO …
-
Teradata system component
TERADATA DATABASE SERVER Teradata Database Server is optimized for viewing and managing large amounts of data. It is fully scalable, …