HELP STATISTICS Syntax Elements (Optimizer Form)

HELP STATISTICS Syntax Elements (Optimizer Form) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

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 if different from the default database.
user_name_2: Name of the containing user for the join index if different from the default user.
join_index_name: Name of the join index whose summary statistics are to be reported.