16.10 - Analyzing Queries and Query Plans - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

Send requests with EXPLAIN modifiers directly to a Teradata system. Sending EXPLAINS through Unity sends the request to one system, but the request could execute on another, so the plan and execution may not be consistent.

When you have a desired query execution plan, develop code and optimize performance directly on the individual systems Unity controls. You can then send queries through Unity, which submits them to any of the systems.