Explain Tab - 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 each Explain step of the query and allows you to export the Explain data.

To view all steps and phase details, you can select All from the Show menu or select Summary to view less Explain data.
Step Information Description
Step Status Icon Indicates the status of each Explain step. In the Completed Queries portlet, the icon is always black, indicating completed.
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.