15.10 - hash_index_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Name of the hash index for which column or index statistics are to be dropped.

database_name
Containing database for hash index if other than the current database.
user_name
Containing user for hash index if other than the current user.

Example: Dropping PARTITION Statistics

This DROP STATISTICS request drops statistics on the PARTITION column only from the PPI table named table_1.

     DROP STATISTICS COLUMN PARTITION ON table_1;

This DROP STATISTICS request drops statistics on the column named column_1 and the PARTITION column from the PPI table named table_2:

     DROP STATISTICS COLUMN (column_1, PARTITION) ON table_2;

This table-level DROP STATISTICS request drops all the statistics, including PARTITION statistics, from the PPI table named table_3:

     DROP STATISTICS ON table_3;

Example: Dropping a Mix of Single-Column and Multicolumn Statistics

Assume that you collect the following statistics on orders.

     COLLECT STATISTICS COLUMN o_orderdatetime,
                        COLUMN o_orderkey,
                        COLUMN (o_orderdatetime, o_orderkey),
                        COLUMN (o_orderkey, o_orderdatetime) 
     ON orders;

The following request drops the single-column statistics on (o_orderdatetime ), (o_orderkey ) and multicolumn statistics on (o_orderdatetime , o_orderkey ) from orders.

     DROP STATISTICS COLUMN o_orderdatetime,
                     COLUMN o_orderkey,
                     COLUMN (o_orderdatetime, o_orderkey) 
     ON orders;

Example: Dropping Statistics on a Geospatial Column

This DROP STATISTICS request drops statistics on the geospatial column sp in table stat_t2.

     DROP STATISTICS COLUMN(sp) ON stat_t2;