Tool Tips and Pop-Up Menus - Visual Explain

Tool Tips and Pop‑Up Menus

Tool tips provide additional information about plan icons displayed in the Teradata Visual Explain window. When a visual plan is displayed in the main window, a pop‑up menu can also be displayed to access additional information about the plan icons.

To display a tool tip

✔ Position the mouse pointer over the icon.

A tool tip appears.

To view general icon‑description information

1 From the Teradata Visual Explain window, right-click the icon.

A pop‑up menu appears.

2 Select Icon Description.

An icon‑information dialog box appears and displays information about the icon selected.

To view detailed icon‑description information

1 From the Teradata Visual Explain window, right-click the icon.

A pop‑up menu appears.

2 Select Detail Information.

A dialog box opens and displays information about the particular icon selected.

Table 21 describes tool tip and pop-up information.

Table 21: Icon Tool Tips and Pop-up Information 

Icon Type	Tool Tip Information	Pop‑Up Information
Table	Table Name Cardinality Type Property Index Fields Partitioned Primary Index Alias Name View Name Partition Count	Icon Description Detail Information Object Definition Indexes Statistics Table Demographics Recommendations Object Use Count
Spool	Spool Name Confidence Level Sorted Cached Estimated Cardinality Compressed Columns Spool Size	Icon Description Detail Information Spool Reference Show Connector
IN-List Spool	The spool name Estimated Cardinality	Icon Description Detail Information
Operation	Operation name Type of join used, in case of a join condition Type of row redistribution Join column in case of a join condition Number of columns involved in the join condition Estimated CPU time required to execute the step Estimated I/O time required to execute the step Estimated network time required to execute the step Estimated heuristic time required to execute the step Estimated time required to execute the step	Icon Description Detail Information
Statement	Statement text	Icon Description Detail Information
Step Number	Step text	Step text Compare Steps: Base Step (makes the selected step the base for comparison in the Select Steps for Compare window) Compare Step (signifies that the selected step is the one to compare to the base step) Remove Sel (removes any previous base step or compare step selections)
Any blank area of the screen	Not applicable	Explain Text Statement Text Teradata Database Configuration Object Definitions Indexes Statistics Show Connectors Summary Information View Pad Index Analysis Object Use Count