View Menu Commands and Toolbar
Use the View menu and toolbar, described in Table 3, to work with the information in the Teradata Visual Explain window. View database configurations, connectors, indexes, object definitions, statistics, and summary information related to the displayed execution plan. Commands on this menu also set the display font, set the zoom level, and provide a view pad (an easy way to navigate large plans).
Command |
Submenu |
Button |
Description |
Toolbars |
|||
|
Standard |
None |
Toggle the Standard toolbar on or off. For more information, see “File Menu Commands and Standard Toolbar” on page 28. |
|
View |
None |
Toggle the View toolbar on or off. For more information, see “View Menu Commands and Toolbar” on page 29. |
|
Plans |
None |
Toggle the Plans toolbar on or off. For more information, see “Plans Menu Commands and Toolbar” on page 33. |
|
Tools |
None |
Toggle the Tools toolbar on or off. For more information, see “Tools Menu Commands and Toolbar” on page 34. |
Status Bar |
None |
None |
Toggle the status bar on or off. |
Spool Space Utilization |
None |
|
View the current and maximum spool space of the current user. |
Compressed |
None |
|
View the data‑flow‑oriented layout of the execution plan. Note: The command is only available when a plan is open. |
Expanded |
None |
|
View the control‑flow‑oriented layout of the execution plan. Note: This command is only available when a plan is open. |
Teradata Database Configuration |
None |
|
View the configuration of the database the execution plan was captured on. Note: This command is only available when a plan is open. |
Summary Information |
None |
|
Toggle the Summary Information window open or closed. The window displays information about the execution plan. Note: This command is only available when a plan is open. |
Show Connectors |
None |
|
Display additional connectors (made up of dashed lines) depicting spool reuse. |
View Pad |
None |
|
Show an overall view of plans that span multiple horizontal and vertical pages. Note: This command is only available when a plan is open. |
Show Demographics |
None |
|
View the demographics of the tables used in the plan. Note: This command is only available when a plan is open. |
Object Use Count |
None |
None |
View a report of all objects used in the displayed plan. Note: This command is only available when a plan is open. |
Current vs. Captured Note: This command and related submenus are only available when a plan is open. |
|||
|
Indexes |
|
View the indexes on objects used in the execution plan. |
|
Object Definitions |
|
View the definitions of the database objects used in the execution plan. |
|
Statistics |
|
View statistics for the tables used in the execution plan. |
Actual vs. Estimated Note: This command and related submenus are only available when a plan is open. |
|||
|
Cardinality |
|
View the actual and estimated cardinality of each spool in the execution plan. |
|
Cost |
|
View the actual and estimated cost of each step in the execution plan. |
Set Font |
None |
|
Display the Font dialog box to change the display font. |
Zoom |
None |
|
Set the size of the display. |
None |
None |
|
Toggle audible notification on or off. |
None |
None |
|
Go to the previous spool reference. |
None |
None |
|
Go to the next spool reference. |
Note: The View toolbar includes toolbar buttons (not described in Table 3) for some of the more commonly used menu commands. See “Window Menu Commands and View Toolbar” on page 36 for a description of these buttons.