Explain Tab - Teradata Viewpoint - 16.00

Teradata Viewpoint User Guide

Teradata Viewpoint
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 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.