Explain Tab - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
User Guide

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 list. To view less Explain data, select Summary.
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.