Viewing the Bulk Compare Results
The results of the bulk compare are saved in text‑file format. Although any standard text editor can be used to view these files, Teradata Visual Explain provides a more flexible viewing method.
To view the results of the bulk compare
1 After the Bulk Compare operation finishes, the Bulk Compare report viewer opens.
2 [Optional] To select a previously saved bulk‑compare file:
The Open dialog box appears.
3 Select an option from the Filter By list.
The default is All. However, the selection remains the same when the application is restarted or the Bulk Compare report viewer is opened subsequently.
Menu Option |
Description |
Unmatched |
Displays only those queries that are different from the attribute selected from the Compare Attribute list. |
Matched |
Displays only the queries whose plans are matched with the base query plan. |
All |
Displays the matched and unmatched queries. |
4 Select an option from the Compare Attribute list.
The default is Complete Information.
For example, selecting Unmatched from the Filter By list and Join Condition from the Compare Attributes list results in the display of queries that are unmatched on the Join Condition attribute. The queries appear in the left pane.
Menu Options |
Description |
Complete Information |
Displays all reports |
Teradata Database Configuration |
Displays the Teradata Database Configuration report. |
Step Information |
Displays the Step Information report. |
Estimated Cost |
Displays the Estimated Cost report. |
Operation |
Displays the Operation report. |
Indexes Used |
Displays the Indexes Used report. |
Index Condition |
Displays the Index Condition report. |
Residual Condition |
Displays the Residual Condition report. |
Join Condition |
Displays the Join Condition report. |
Join Order |
Displays the Join Order report. |
Source Attributes |
Displays the Source Attribute report. |
Target Attributes |
Displays the Target Attributes report. |
For information about reports, see Chapter 10: “Viewing Comparison Reports.”
5 Select a query from the QCD list in the left pane.
The corresponding information displays in the text window in the right pane.
6 [Optional] From the Bulk Compare report viewer, double-click on the cells in the left pane to open the report window.
To control the number of windows displayed, click View>Multiple Windows. Multiple windows appear per query plan for the selected attributes. New windows are opened for each query plan. To use the same set of windows for the attributes of each plan, clear this command.
7 [Optional] To display the statement text, server/source information, or visual plan of any query:
a Right‑click on the query.
The shortcut menu appears.
b Select a command.
Perform any of the commands listed on the shortcut menu, including printing or saving the information that is displayed in the text pane.