You can specify the following options.
- TEMPORARY
- The name of the global temporary source table from which statistics are to be copied to the target table.
- database_name
- The containing database for the table_name_2, join_index_name, or hash_index_name, if other than the default database.
- user_name
- The containing user for the table_name_2, join_index_name, or hash_index_name, if other than the default database.
- table_name_2
- The name of the base source table from which statistics are to be copied to the target table.
- 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.
- column_name_3
- The column name set, partition, or index for which statistics are to be copied from the source table to the target table.
- PARTITION
- The column name set, partition, or index for which statistics are to be copied from the source table to the target table.