16.10 - Managing Query Performance - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

You can monitor queries using the Teradata Viewpoint Query Monitor portlet and other tools and utilities to identify poorly performing queries. Poor query performance is usually due to:

This section also covers the performance issues related to transaction rollbacks, which occur when a query fails to complete. See Working with Transaction Rollbacks.