Execution Plan Options - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
Icon Title Description
Get Execution Plan Enabled if the Connection Profile is connected. The command executes an EXPLAIN command for the SQL Statement and displays the execution plan in the Execution Plan view. If you selected the Text plan type, the Execution Plan is displayed as text. If you selected the Graphic plan type, the INSERT EXPLAIN command executes and inserts the plan steps in the QCD database. The Execution Plan is then displayed in a tree node hierarchy.
Get Execution Plans with Statistics Enabled if the user's connection profile is connected and the user has chosen to use the Graphic plan type, in the SQL Development > Execution Plan View option. The command executes an INSERT EXPLAIN WITH STATISTICS command for the SQL Statement. The statistic data is placed in the TableStatistics table within the QCD database. The statistics data is then gathered by running a HELP STATISTICS command with the given table name, column name, and query ID. HELP STATISTICS retrieves the information from the TableStatistics table.
Compare Execution Plans Enabled if the Connection Profile is connected, and you selected to use the Graphic plan type in the SQL Development > Execution Plan View option. The command displays a list of the execution plans contained in the QCD (Query Capture Database)for the given profile. The list is displayed in the Teradata View. The name of the profile displays in parenthesis within the Execution Plan List tab label.