- TEMPORARY
- Requested indexes are defined on a materialized global temporary table. This keyword is valid only for global temporary tables.
- database_name_1
- user_name_1
- Containing database or user for table_name if something other than the current database or user.
- table_name
- Table on which a report of all primary and secondary indexes is desired.
- database_name_2
- user_name_2
- Containing database or user for join_index_name, hash_index_name, or view_name if something other than the current database or user.
- join_index_name
- Join index on which all primary and secondary indexes are reported.
- hash_index_name
- Hash index on which a report of all primary indexes is desired.
- view_name
-
Name of a single-table view for which index information is required.
You can only request HELP INDEX reports for single-table views.
- column_name
- Column in a column list for which an index or index list is desired. Use this syntax to exclude primary, secondary, join, and hash indexes defined on columns for which you are not interested.