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.
A tool tip appears.
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.
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.
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: |
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 |