Summary Optimizer Statistics Attributes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The data types for the table attributes reported by a summary HELP STATISTICS request are as follows:

Attribute Description Data Type
Date The date on which statistics were last collected. CHARACTER(8) CHARACTER SET UNICODE
Time The time at which statistics were last collected. CHARACTER(8) CHARACTER SET UNICODE
Unique Values An estimate of the number of unique values for the specified column set. VARCHAR(20) CHARACTER SET UNICODE
Column Names The names of the columns for which summary statistics are reported. VARCHAR(2000)

The requirement of a 2,000 character maximum derives from the maximum number of columns per index and the maximum length of a column name plus overhead: (64 * 30) + 63 = 1983 characters.

On a standard language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET LATIN.

On a Japanese language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET UNICODE if a multibyte site-defined session character set such as UTF-8, UTF-16, Chinese, or Korean is used.

For any other language support system, the data type for Column Names is VARCHAR(2000) CHARACTER SET UNICODE.

The server character set for Column Names is Unicode, which gets translated to the client character set.

If there is multibyte character data, Column Names uses the UTF-8, UTF-16, or some other character sets that supports multibyte client character sets.