Explain Tab for Teradata Aster - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

The Explain tab 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. You can also export Explain data.

To view all steps and phase details, click Show all . Alternatively, click Show summary 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.