DROP STATISTICS Syntax | SQL Statements | Teradata Vantage - 17.05 - DROP STATISTICS Syntax (QCD Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
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.