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.
-
Click Open.
The plans appear in the main window.
Load and View Execution Plans