Explain View for Teradata Aster

Teradata Viewpoint User Guide

prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

The Explain view displays the Explain text that shows the progress of a query. Each Explain step has a colored box that indicates the status of the step. This information is read-only.

By default, all steps and details are displayed. Tap Show summary only to view a shortened version of the Explain data.
Step Information Description
Step Status Icon

Indicates the status of each Explain step:

  • Completed steps are at the top of the list and indicated by a black box.
  • Active steps are indicated by a pulsating box (flashes gray and white).
  • Steps to run are at the bottom of the list and indicated by a white box.
Time Duration of the step
Type Category of step, such as Command, CommitPreparedTransaction, DataTransfer, Import, PrepareTransaction, and Query
Phase/Detail Summarized or full explanation of query that executes in this step. Can be used to diagnose the cause of the failure or slowness.