DROP STATISTICS Syntax | SQL Statements | Teradata Vantage - DROP STATISTICS Syntax (QCD Form) - Analytics Database - Teradata Vantage

DROP { STATISTICS | STATS | STAT }
  FROM QCD_name
  [ON] [ database_name. | user_name. ] table_name

  [ COLUMN { { column_name | PARTITION } |
             ( { column_name | PARTITION } [,...] )
           } |

    INDEX { index_name | ( column_name [,...] ) }
  ] [;]

Syntax Elements

FROM QCD_name

Name of the QCD database from which statistics on the specified table columns and indexes are to be dropped from the TableStatistics table.

database_name | user_name

Name of the containing database or user for table_name if different from the current database or user.

table_name

Name of the table for which sampled column and index statistics are to be dropped.

COLUMN column_name

Set of non-indexed columns for which sampled statistics are to be dropped.

You cannot drop statistics on a UDT column.

COLUMN PARTITION

Statistics are to be dropped on the system-derived PARTITION column for a table.

You cannot reference the PARTITION#Ln columns of a table in a DROP STATISTICS request.

For more information about the PARTITION column, see Collecting QCD Statistics on the PARTITION Column of a Table.

INDEX index_name

Name of the index for which sampled statistics are to be dropped.

INDEX column_name

Column set for which sampled statistics are to be dropped.