17.05 - HELP STATISTICS Syntax Elements (Optimizer Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
CURRENT
Report extrapolated table-level summary statistics.
STATISTICS
Report summary statistics.
You cannot request information about detailed statistics using the INDEX or COLUMN options. Instead, you must use SHOW STATISTICS to retrieve this information. See SHOW STATISTICS.
TEMPORARY
Summary statistics information for a temporary table.
database_name_1
Name of the containing database for database_object_name if different from the default database.
user_name_1
Name of the containing user for database_object_name if different from the default user.
table_name
Name of table for which to display information.
database_name_2
Name of the containing database for the join index or hash index if different from the default database.
user_name_2
Name of the containing user for the join index or hash index if different from the default user.
join_index_name
Name of the join index whose summary statistics are to be reported.
hash_index_name
Name of the hash index whose summary statistics are to be reported.