Control Poorly Performing Queries | Teradata Vantage - 17.00 - 17.05 - Controlling Poorly Performing Queries - Advanced SQL Engine - Teradata Database

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.