Control Poorly Performing Queries | Teradata Vantage - Controlling Poorly Performing Queries - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

To control a query:

  1. In the Query Monitor portlet, click on the session with the identified bad query.

    The Details view appears.

  2. You can use the Tools menu to:
    • Change the query priority
    • Abort the query
    • Abort and log off the session
    Use the following guidelines when considering whether to abort a session:
    • Do not abort the session if it is still running other queries.
    • If the session is not running other queries:
      • If the query is a SELECT statement, you can safely abort the query.
      • If the query includes an INSERT, UPDATE, DELETE, or other statement that changes data, aborting a partially completed query may cause data problems.