Use Teradata Visual Explain to visually compare one or more execution plans to a designated base plan. Red arrows indicate differences in the depicted plan.
1 Click .
The Select Execution Plans for Visual Compare dialog box appears. The following selections are available:
2 [Optional] Use one of the following options to select plans from a database:
a In the tree view, right-click on the Query Capture Databases node to display the shortcut menu. Select the Browse QCD menu item to display the Available QCD names in the tree view.
b To select a plan associated with a workload, use one of the following options in the Workload box:
for a list of available workloads.c To select a specific plan, use one of the following options:
Note: In this field, the % and _ symbols can be used as wildcard characters and can be used in any combination. The % symbol represents any string of zero or more arbitrary characters. For example, query% would match query, query1, query12, and so on. The _ symbol represents one arbitrary character; therefore, any single character is acceptable in the position in which _ appears.
Type a query ID number in the Query ID box.
To select a range of plans, type a range in the Query ID box.
For example, type 1-100 or 1,3,6-10.
d To select plans from a different server:
i Close the Browse QCD Plans dialog box.
i Close the Browse QCD Plans dialog box.ii Click the Disconnect button in the Status Bar of the Open Plan Tree window.
iii Click the Connect button in the Status Bar of the Open Plan Tree window.
iv Type logon information.
v Right-click on the Query Capture Databases node to display the shortcut menu. Select the Browse QCD menu item to display the available QCD names.
vi Select a specific QCD from the tree view. Right-click the QCD to display the shortcut menu. select the Browse Plans menu item to display the Browse QCD Plans dialog box.
3 [Optional] To select plans that are open:
a Click Browse Open Plan(s). The plans are listed under Select Execution Plans.
b Click Open to display the plans.
4 [Optional] To select offline plans:
a In the tree view, click the Offline Plan node and select Browse Offline Plans.
b From the Open dialog box, select one or more plans.
c Click Open to display the plans in the Offline Plan node.
d Click Add to add the selected plans to the Selected Execution Plans list.
5 [Optional] To load one or more DBQL plans:
a In the tree view, right-click on the DBQL XML Plan node to open the shortcut menu.
b Select the DBQL Plans menu item to display the Select DBQL Criteria dialog box.
c Under Selection, use one of the following options:
d [Optional] Set DBQL filter options:
i DBQL filter options are present in the Select DBQL Criteria dialog box.
i DBQL filter options are present in the Select DBQL Criteria dialog box.ii Click OK.
e The filtered DBQL plans are populated below the DBQL XML Plan node in the tree view.right-click on the
f In the Available Execution Plans, right-click on the QueryID to open the shortcut menu and select the Add menu-item checkbox in the Available Execution Plans list.
g To select a base plan for the comparison, double-click on a row under Selected Execution Plan.
6 [Optional] Use the following steps to see the complete statement text:
a Select a QueryID from QCD, DBQL, or a file name from the Offline Plans in the tree view.
b Right-click on the selected item to open the shortcut menu.
c Select the Statement Text menu item to open the Statement Text dialog box.
d Select a statement in the grid.
e Click the icon.
7 To select a base plan for the comparison, double-click on a row under Selected Execution Plan. The plan is moved to the top of the list and highlighted in green.
8 Select the check box in the Compare column next to the each plan to be compared.
9 Click Compare.
10 The differences are highlighted by red arrows next to the appropriate steps. Position the mouse pointer so that the cursor is over the red arrows. To see tool tips explaining the differences, see “Tool Tips and Pop‑Up Menus” on page 48.
Figure 31: Execution Plans - Visual Compare