Teradata Visual Explain (VE) is a tool that visually depicts the execution plan of complex SQL requests in a graphical manner.
Teradata VE presents a graphical view of the request broken down into discrete steps showing the flow of data during execution. It has the ability to compare multiple execution plans side by side.
Because comparing optimized queries is easier with Teradata VE, application developers and database administrators can fine-tune the SQL statements so that Teradata Database can access data in the most effective manner.
In order to view an execution plan using Teradata VE, the execution plan information must first be captured in the Query Capture Database (QCD) by means of the Query Capture Facility (QCF).
Teradata VE reads the execution plan, which has been stored in a QCD, and turns it into a series of icons.