After an execution plan has been captured into the QCD (using the INSERT EXPLAIN statement), use Teradata Visual Explain to view the plan graphically or textually. To view a saved execution plan perform the following:
- Click . The Open dialog box appears.
- Select a plan (.vec file). When a file is selected, the plan description appears in the Description box. If the file contains more than one plan, the Description box identifies how many plans the file contains.
The plans appear in the main window.Load and View Execution Plans