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

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
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.