Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

ColumnName

  • If more than one column or expression is specified, each column or expression is separated by a comma.
  • The maximum number of columns is 64.
  • If expressions are in the list, the maximum number of columns can be reduced past the limit of 64, depending on the combined total size of the text in the expressions.
  • If the combined total size of the expression text causes the maximum column limit to be less than the actual number of columns in the list, an error occurs.

FieldIdList

The FieldIdList column is NULL for fields that involve expressions.

MaxInterval and MaxValueLength

If these statistics are collected with system determined maximum intervals and maximum value length, the MaxInterval and MaxValueLength columns are NULL.

Possible Values for StatsType

Value Description
T Table
I Join Index
N Hash Index
V View
Q Query
L Link Row

SampleSizePct

If sampling is not used, the SampleSizePct column is set to 0 or 100.

StatsSource

The StatsSource column records the method by which this statistic is acquired. For information about the possible values for the StatsSource column, see "StatsSource Column."