indexed_item - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples
Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
TEMPORARY
Statistics are to be dropped for a materialized global temporary table.
This keyword is not valid for permanent tables and if you use it with a table defined as permanent, an error is returned.
If you do not specify TEMPORARY, but the referenced table is a global temporary table, the statistics are dropped for an empty table, but on the base global temporary table rather than its materialized instance.
If you specify TEMPORARY correctly, but no materialized instance of the global temporary table exists in the session, the system materializes an instance with all of the statistics defined on the base temporary table before dropping statistics for it.
database_name
Containing database for table_name, join_index_name, or hash_index_name if something other than the current database.
user_name
Containing user for table_name, join_index_name, or hash_index_name if something other than the current database.
table_name
Name of one of the following database objects whose statistics are to be dropped.
  • Table or global temporary table
  • Single-table view

    You can only request HELP STATISTICS reports for single-table views.

  • Single-table query

    You can only request HELP STATISTICS reports for single-table queries.

You cannot drop statistics on journal or global temporary trace tables because you cannot collect statistics on those database objects.
join_index_name
Name of the join index for which column or index statistics are to be dropped.
hash_index_name
Name of the hash index for which column or index statistics are to be dropped.