Displaying Differences in Explain Text
Use Teradata Visual Explain to display the differences in the Explain text for two plans.
To display Explain text differences
1 Click .
The Select Execution Plans for Explain Text Differences window appears.
Figure 36: Select Execution Plans for Explain Text Differences
2 From the Open Plans window, select one of the following options:
3 To select plans from a database:
a In the tree view, right-click the Query Capture Databases node to open the shortcut menu.
b Select the Browse QCD menu item to list the available QCD names in the tree view.
c Select a specific QCD from the QCD names in the tree view.
d Right-click the QCD name to open the shortcut menu.
e Select the Browse Plans menu item to display the Browse QCD Plans dialog box.
|
To load … |
Do the following … |
|
The plans associated with a workload |
In the Workload box, enter the workload name or click |
|
A specific plan |
In the Query Tag box, enter the name of the query tag. [Optional] In this field, the percent sign (%) and underscore (_) can be used as wildcard characters and can be used in any combination. The percent sign (%) represents any string of zero or more arbitrary characters. For example, query% would match query, query1, query12, and so on. The _ represents one arbitrary character; therefore, any single character is acceptable in the position in which the underscore character appears. – or – Enter one query ID number in the Query ID box. |
|
A range of plans |
In the Query ID box, enter a range. For example, enter 1-100 or 1,3,6-10. |
|
Plans from a different server |
In the tree view, select Open Plan to open the shortcut menu. Click the Connect menu item. After entering logon information, open the Browse Plans menu item for QCD, Browse DBQL Plans menu item for DBQL, and menu item Browse Offline Plans for Offline Plans. |
to get a list of all available workloads.
4 To select plans that are already opened:
a Select Opened Plan.
b Click Browse Open Plan(s).
The plans are placed in the Available Execution Plans list.
5 To select offline plans:
a In the tree view, right-click Offline Plan to open the shortcut menu.
b Select the Browse Offline Plan menu item to display the Open dialog box. Choose the plans from the Open dialog box.
When selecting a file, the description of the plan appears in the Description box. If the file contains more than one plan, the Description box includes the number of plans that the file contains.
c Click Open to place the plans in the Offline Plan node in the tree view.
6 [Optional] To load one or more DBQL plans:
a In the tree view, right-click DBQL XML Plans to open the shortcut menu.
b Select the Browse DBQL Plans menu item to open 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.
iii The filtered DBQL Plans are listed below the DBQL XML Plan node in the tree view.
iv In the Available Execution Plans list, right-click on a QueryID to open the shortcut menu.
v Select the Add menu item to enter a check mark in the QueryID checkbox.
vi Enter data in the Select Criteria dialog box.
See “To view the execution plan graphically or textually from the DBQL” on page 77 for more information about completing the Select Criteria dialog box.
The Select Criteria dialog box closes and the Select Plans from DBQL dialog box appears.
7 [Optional] To see complete statement text, select a statement and then click . For more information on the Statement Text dialog box, see “Viewing Statement Text” on page 83.
8 Select a base plan for the comparison by double-clicking on a row in the Selected Execution Plans list. This moves the plan to the top of the Selected Execution Plans list and the plan is highlighted in green.
9 Choose a plan to compare to the base plan by selecting the checkbox in the compare column next to the plan.
Note: Only two plans can be compared at a time.
10 Click Compare.
The compare window opens. The differences in the cells are highlighted in red.
Figure 37: Compare Window
11 Use the commands on the Navigate menu or the corresponding buttons on the toolbar to move from one difference to another. For more information about these commands, see “Navigate Menu Commands and Toolbar” on page 35.
12 Click File>Close to close the compare window.