17.05 - collection_source - 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)

Following are the ON clause options.

TEMPORARY
Statistics are to be collected for a materialized instance of a global temporary table in the current session. A request to collect statistics on a global temporary table materializes the global temporary table, if the table is not already materialized in the session.
You cannot use this option to collect statistics on a geospatial NUSI. This keyword is not valid for permanent tables.
You cannot collect system-derived PARTITION or PARTITION#L n statistics for global temporary tables.
database_name
The containing database for the table_name, join_index_name, or hash_index_name, if other than the default database.
user_name
The containing user for the table_name, join_index_name, or hash_index_name, if other than the default database.
table_name_1
The name of the table or global temporary table for which column or index statistics are to be collected. You cannot collect statistics on journal tables.
join_index_name
The name of the join index for which statistics are to be collected.
hash_index_name
The name of the hash index for which statistics are to be collected.