Display Statistics Tab - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

The display shows the list of tables on the left side and the statistical attributes and data on the right side. When you select a column from one of the tables on the left, the statistical data is reflected in the information on the right.

The Get Execution Plan with Statistics option 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.