15.00 - Teradata Visual Explain User Guide - Visual Explain

Product: Visual Explain
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-27

Preface
Audience
Supported Releases
Prerequisites
Changes to This Book
Related Documentation
Product Safety Information
Chapter 1 Introduction
About Teradata Visual Explain
How Teradata Visual Explain Can Help You
How Teradata Visual Explain Works
Prerequisites
Chapter 2 Interface
Windows
Teradata Visual Explain Main Window
Summary Information Window
Teradata Visual Explain Bulk-Compare Window
Menu Bar and Toolbars
File Menu Commands and Standard Toolbar
View Menu Commands and Toolbar
View Menu and Toolbar for the Bulk-Compare Report Viewer
View Menu and Toolbar for the Textual Compare Report
Plans Menu Commands and Toolbar
Tools Menu Commands and Toolbar
Navigate Menu Commands and Toolbar
Window Menu Commands and View Toolbar
Help Menu Commands and Standard Toolbar
Toolbar Access
Display Icons
Statement Icons
Retrieval-Method Icons
Data-Redistribution-Method Icons
Table and Spool Icons
Derived-Table Icons
Index Icons
Aggregate-Step Icons
Join-Method Icons
Other Operation Icons
Error Icon
Tool Tips and Pop-Up Menus
Connectors
Dialog Boxes and Shortcut Menus
Dialog Boxes
Shortcut Menus
Online Help
Chapter 3 Getting Started Using Teradata Visual Explain
Specifying the Type of Connectivity
Defining a Data Source and Connecting through ODBC
Connecting through CLIv2
Setting Up a Query Capture Database
Upgrade or Revert QCD Version
Displaying an Execution Plan
Use Teradata VE to Insert an Execution Plan into a QCD
View the Execution Plan
Other Options
Viewing Explain Text
Viewing Statement Text
Adjusting Window Height and Width
Entering a Query and Viewing Its Execution Plan
Disconnecting and Closing Teradata Visual Explain
Disconnecting from a Teradata Database
Closing Teradata Visual Explain
Setting the Default Directory
Setting Display Options
Setting General Options
View Low Level Error Log
Chapter 4 Privileges
Using the Basic Functions
Using the Administrative Functions
Using the Administrative Functions
Creating Restricted Views
Chapter 6 Administering the QCD
Managing the QCD
Setting Up a New QCD
Creating QCF-Related Views and Macros in a QCD
Upgrading a QCD
Cleaning Up a QCD
Deleting Execution Plans from a QCD
Deleting QCD-related Database Objects
Deleting Workloads
Deleting the QCD
Deleting Demographics
Security
Creating a User
Changing User Rights on the QCD
Exporting QCD Data to a File
Exporting Execution Plans
Exporting Workloads
Exporting QCD Data
Importing QCD Data from a File
SQL Statement Failed Dialog Box
Chapter 7 Comparing, Printing, and Saving Execution Plans
Visual Comparison
Textual Comparison
Comparing Steps in Execution Plans
Displaying Differences in Explain Text
Finding Differences in Compared Execution Plans
Comparing Multiple Plans Using Bulk Compare
Viewing the Bulk Compare Results
Setting the Variance Threshold
Restarting Bulk Compare
Printing
Printing an Execution Plan
Printing Textual-Compare Reports
Previewing Before Printing
Saving an Execution Plan
Chapter 8 Working with Execution Plans
Loading and Viewing an Execution Plan
Locating a Step in an Execution Plan
Navigating Execution Plans
Locating Spool References
Entering a Query and Viewing Its Execution Plan
Setting or Resetting Random AMP Samples
Setting or Resetting Cost Parameters
Executing an SQL Query
Analyzing Plans to Improve Performance
Analyzing Plans
Viewing Index Recommendations for Tables
Viewing Current vs. Captured Indexes, Object Definitions, and Statistics
Viewing Indexes in the Tables
Viewing Objects Used in the Execution Plan
Viewing Statistics for Tables Used in the Execution Plan
Viewing Actual Versus Estimated Cardinalities
Compare Actual to Estimated Cost
Viewing Query Execution
Viewing Teradata Database Configuration
Viewing Object Use Count Report
Chapter 9 Data Demographics
View Data Demographics
Control the Number of Open Windows
View Data Demographics from the View Menu
View Data Demographics from the Visual Plan
Data Demographics Menu Options
Data Demographics Toolbar Icons
Data Demographics Window Controls
Selecting Bar or Line Graphs
Move Through Table Pages
Data Demographics Graph Types
Disk Space Utilization Graph
Spool Space Utilization Graph
Row Count/Average Row Size Graph
Blocks Distribution Graph
Statistics Details Graph
Save or Print Data Demographics
Chapter 10 Viewing Comparison Reports
Display a Report
Report Descriptions
Complete Information Report
Teradata Database Configuration Report
Step Information Report
Estimated Cost Report
Operation Report
Operands Report
Residual Condition Report
Join Condition Report
Join Order Report
Source Attributes Report
Target Attributes Report
Indexes Used Report
Index Condition Report
Chapter 11 Using the Command Line Interface
Command Line Switches
Terms Used in Visual Explain
Connecting to a Teradata Database
View Execution Plan(S)
Opening Offline Execution Plans
Opening Online Execution Plans
Comparing Execution Plans Visually
Comparing Execution Plans Using Text Reports
Displaying Differences in Explain Text of Execution Plans
Comparing Multiple Execution Plans Using Bulk Compare
Chapter 12 Working with Other Teradata Applications
Starting Teradata Index Wizard
Starting Teradata System Emulation Tool
Starting Teradata SQL Assistant
Starting Teradata Statistics Wizard
Glossary

Back to home page