collection_source - Advanced SQL Engine - Teradata Database

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.