Explain Tab - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.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.