15.10 - ON Clause - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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#Ln 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.