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