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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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.