Specifies the table, join index, or hash index.
- TEMPORARY
- The SQL create text or the SQL create text and the collected statistics are to be displayed is for a global temporary table.
- database_name
- user_name
- Name of the containing database or user for database_object_name.
- table_name_1
- Name of one of the following database objects whose summary statistics and, optionally, detailed statistics are to be reported.
- join_index_name
- Name of join index whose summary statistics and, optionally, detailed statistics are to be reported.
- hash_index_name
-
Name of the hash index whose summary statistics and, optionally, detailed statistics are to be reported.